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

In my article “The most important changes to VBA in Excel 2010“ from 08/05/2009, I had already reported about some changes to the VBA object model in Excel 2010. Also, I had started the development of an application for parsing and analysing all VBA objects, methods, properties and constants of the VBA libraries included in the Office apps. Just recently, I got the time to finish the development of this application.

The application is freeware and can be downloaded at the end of this article. The output tables are protected, however the password can be found in code which is unprotected and can be viewed by everyone. Please note, that the workbook itself and the copyright sheet are also protected by a password and this password is not publicly accessible.

The application referencies to the TLI Library „TlbInf32.dll“ in the windows system folder providing functions for scanning type libraires. Important note: the TLI Library needs to be installed and correctly registered on your system. My application can not work without this library. And please note that this library is not included in the download archive.

Excel VBA Typelib Scanner

Read more

This article lists the most important articles I have posted about the Technical Preview of Office 2010. At this point, thanks to all visitors and the positive feedback via email. Office 2010 Beta is now publicly accessible and I will also write some articles about the new version. However, most informations of my previous posts are also applicable to the Beta. I have sorted this list by publishing date.

Read more

Microsoft offers for several Office versions the administrative tempates, which especially allows system administrators to maintain and configure various settings and options for Microsoft Office in a very convenient way. The templates are can be downloaded for free at the Microsoft Download Center.

So, everyone can use them, for example at home or in the small office. However, if you use them, please do this very carefully. Most settings are explained in the templates and also accessible using the Office interface. However, some of them are only accessible (excepted some uncomfortable registry hacks) via the administrative templates and you should know what you are doing before changing these values. Added on 23/04/2010: at the time, I wrote this article, Office 2010 was still beta. So it is possible that some statements in this article may not apply to the final version of Office 2010.

In this article, I will explain how to use the administrative templates on a local computer and show some sample settings for Office 2007 and Office 2010. If I got some spare time, I will report about more settings for the Office applications in further posts. First, we have to download the adminstrative templates for each Office version and install them. This can be done by just executing the downloaded file, which unpacks the templates to a folder you can choose. The following image shows a screenshot for the folder structure after unpacking the files:

Administrative Templates

Read more

I’m regularly visiting the blog from Gray Knowlton who leads the product managment team for Office Developers. Among other very interesting articles about MS Office 2010, he had announced two applications, I have been impatiently waiting for. These apps are now available and can be downloaded from the Microsoft Download Center.

The first application help the users and administrators to evaluate and check out incompatibilities when installing or upgrading to MS Office 2010. The second application inspects your VBA Code for incompatibilites. This article presents the „Office Environment Assessment Tool – shortly OEAT“. In a further post, I will present the „Office VBA Compatibility Inspector“.

First we have to download OEAT from the Microsoft website. After the download, just unzip the OEAT application in a folder of your choice. When running the tool, you’ll see following screen:


Read more

As mentionned in my previous article, I’m following the excellent blog posts from Gray Knowlton. Gray already presented there the „Microsoft Office 2010 Code Compatibility Inspector – shortly OCCI“, I would like to report about my experiences with this tool. This application is currently at its beta stage, so we can’t expect all will work fine.

First, lets download the application from the Microsoft Download Center and the unpack the contents of the zip archive. I my case, trying to unzip the file to an inexistent folder on my hard disk leads to an error message telling me that the folder can not be created. No matter, I unzipped the archive contents to the folder proposed by OCCI. This works. The we can call the OCCI installer.


Read more

I also scanned the different versions of MS Access and stored the results in an Excel file.

Access VBA Libraries

Read more