Excel Ticker

Excel Ticker

22. August 2010
by Mourad Louha
5 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

5. April 2010
by Mourad Louha
0 comments

VBA Add-In for highlighting rows and columns in an Excel sheet

For some time now, I’m evaluating my web server log files with Excel 2010. Yes, there are many other good tools for analyzing logfiles on the market and I’m also using some of them. However, Excel 2010 provides the function … Continue reading

29. March 2010
by Mourad Louha
0 comments

Creating UTF-8 XML files in VBA for use in Adobe Flash

My partner – www.designimsinn.de (German) – and me have recently redesigned and implemented an Adobe Flash based CD for one of our customers. This multilanguage CD (German, English and Russian) contains many external documents to the CD interface and stored … Continue reading