Excel Ticker

Excel Ticker

22. August 2010
by Mourad Louha
1 Comment

Create VBA Application Objects by using the Windows API

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
3 Comments

Get the path and file name for a file location using formulas or VBA in Excel

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

10. August 2010
by Mourad Louha
1 Comment

Read and write Excel and other Office documents with PHP

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