(C) 2009 - 2018 by Mourad Louha · All rights reserved

This article presents my first version of my free Excel Add-In (Version 0.75 Build 151110) for calculating large numbers in Excel. The Add-In (you can download the file at the end of this article) currently implements functions for the addition, subtraction, multiplication and exponentiation of large numbers. The code in the Add-In is password protected; however you can unprotect the VBA project by using the password “excel-ticker” (without the quotes). Please also read the copyright notice and license terms in the last section of this article.

The Add-In is also digitally signed with a certificate which was issued to me by the company “TC TrustCenter GmbH, Germany”. So, only files including this digital signature have been created and published by me.

Naming conventions of the functions in the Add-In

The Add-In includes the functions described below, which can be accessed, for example, through the category “User defined” of the select function box in Excel. Each function of the Add-In is available in English, German and French.

VBA Large Numbers

Read more

Some people from my english speaking audience asked me a few days ago, if it may be possible to translate my german article published on 11/27/2009 about the comparison between the functions included in Excel 2003, 2007 and 2010. The file listing the functions of the different Excel versions is also presetted to English and can be downloaded at the end of this article. Below a screenshot from the worksheet:

Office 2010 Plus Functions

Read more

Some time ago, I read the interesting blog post „Function Improvements in Excel 2010” on the Microsoft Excel Team Blog. They report about the changed formulas in Excel 2010 and about the improvements made to the calculation algorithms for these formulas. I’m not a statistician and I can’t really use all those statistical formulas, but I’m curious and I would like to examine how the results returned by the affected formulas differ in the different Excel Versions. For doing this, I have choosen the GAMMALN() function because this formula just only needs one argument. You can download a sample workbook at the end of this article.


Read more

Someone asked in my favorite German forum about Microsoft Office if it is possible to dynamically build a reference to an Excel range located in another file. The following solution addresses a range in an external file by using the Excel functions OFFSET(), INDIRECT() and ADDRESS().

Let’s suppose, we have some files which all have an identical structure for the data. The screenshot below shows 4 files, each one providing fictive data for the days of one week. The values are stored in each file in the cells C4 to C10 of a sheet named “Data”.

Excel 2010

Read more

Someone asked in the German Microsoft Answers Forum, if it is possible to get access to an Excel instance and then execute code from this instance. This gave me the idea to enumerate all open Excel instances by using the windows API and then try to access them with VBA.

The article describes how to create VBA Application Objects using the Windows API. Please note, that this article is a little bit shortened translated version of the two articles I wrote in the German section of this blog. The descriptions of the code in this article require that you are familiar with VBA and the use of controls like TreeViews, ListViews and Windows API functions. A sample application can be downloaded at the end of this post. The VBA code is unprotected.

Windows Enumerator

A certainly well-known way to retrieve an object reference in VBA to another Excel Application Instance is the use of the “GetObject()” method. For example, by using the statement Set xlApp = GetObject(, “Excel.Application”), you can get a reference to the Excel instance, which was firstly opened. However, it is not possible to retrieve a reference to more Excel instances, if you do not know the name of an opened workbook in these instances.

Read more

Creating a rotating image gallery in Excel VBA

Categories: Addins and Extra Tools, Development, Excel, Office, Tools, VBA
Comments Off on Creating a rotating image gallery in Excel VBA

Some days ago, someone posted in my favourite german office forum a question how to create an image gallery with rotating images in Excel VBA. The images may rotate in a circular orbit when the user clicks on an image. “Image 1” should take the position of “Image 2”, “Image 2” the position of “Image 3” and so on. Following image shows a screenshot of the sample Excel file which you can download at the end of this article and includes also the VBA Code.

Excel VBA Animator

Read more