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

VBA Objects in Excel 2010, Excel 2007 and Excel 2003

In my previous post „Excel VBA Type Library Scanner“, I had presented my application for scanning and parsing type libraries. However, my application needs the TLI Library „TlbInf32.dll“ to be installed and registered on the system where my application will run. For those people who do not want to install the TLI Library or have not access to it, I have now scanned the Excel 2010, 2007 and 2003 VBA Libraries on my system and exported the results to a separate workbook. You will find the download link for this file at the end of this article.

Excel VBA Libraries

You will find in this workbook following worksheets:

  • Compare.Full
    This sheet compares all objects, methods, events, properties and constants found in Excel 2010, 2007 and 2003.
  • Compare.Objects
    This sheet only lists all objects of the different Excel versions and compares the objects from 2010 with the previous versions.
  • Compare.Properties
    This sheet compares only the properties in the different versions.
  • Compare.Methods
    This sheet compares only the methods and events.
  • Compare.Constants
    This sheet compares the constants found after the scan.
  • 2010, 2007 und 2003
    These sheets are containing the scan results for each version of Excel (2010, 2007 and 2003). The arguments for the methods and events have also been scanned.

Please note, that I can not give any warranty about the correctness or accuracy of the informations found in the file. Please also consider that it may be possible that some features or functions may change until the final relase of Office 2010. If you find an error or something wrong, it would be great, if you can inform me by writing me an email to vba (at) maninweb (dot) de. Finally, here is the download link for the file:

This article has also been published in German and in English on the following sites:



No comments yet.

Leave a Reply