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.
You will find in this workbook following worksheets:
This sheet compares all objects, methods, events, properties and constants found in Excel 2010, 2007 and 2003.
This sheet only lists all objects of the different Excel versions and compares the objects from 2010 with the previous versions.
This sheet compares only the properties in the different versions.
This sheet compares only the methods and events.
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:
- Excel Ticker Blog, German
- Professional Excel Solutions by Maninweb.de, English
- Professional Excel Solutions by Maninweb.de, German