14. November 2010
by Mourad Louha
0 comments
This fourth part of my article series about the calculation of very large numbers in Excel talks about the exponentiation of two large numbers. If we consider the original problem (see my first article) which was the calculation of 80 … Continue reading
13. November 2010
by Mourad Louha
0 comments
In the last two articles, we have implemented two VBA functions for adding and subtracting two large numbers represented as strings. Now, it’s time to implement a function able to multiply two large numbers in a very fast way. The … Continue reading
13. November 2010
by Mourad Louha
0 comments
In the first article of this series, I presented a VBA function for adding two large numbers represented by strings. This article presents a function for performing a subtraction for two large numbers. This function will, like the adding function, … Continue reading
13. November 2010
by Mourad Louha
6 Comments
Some time ago, there was a very interesting discussion in my favorite German “Office-Lösung” Office forum. A user asked, if it is possible to calculate the value of 80 ^ 200 in Excel. As the precision is limited in Excel … Continue reading
22. August 2010
by Mourad Louha
1 Comment
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 … Continue reading
22. August 2010
by Mourad Louha
5 Comments
I am currently studying some Windows Registry accesses from Excel & Co. A formula in an Excel sheet helps me to split these entries into its components; meaning the path elements and the value. The location where a file is … Continue reading