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
22. August 2010
by Mourad Louha
1 Comment
A user asked in my favorite German forum “Office Lösung” about MS Office, if it is possible to automatically update an image from a web server in Excel. The user also posted some sample links and wished that the update … Continue reading
10. August 2010
by Mourad Louha
1 Comment
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 … Continue reading
10. August 2010
by Mourad Louha
1 Comment
Sometimes, I also use PHP for implementing features for my websites. A very interesting and professional managed open source class library for reading and writing Excel documents in PHP is the “PHPExcel” project which can be found on CodePlex. For … Continue reading