ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get objects property names in run-time? (https://www.excelbanter.com/excel-programming/291279-re-get-objects-property-names-run-time.html)

Tom Ogilvy

Get objects property names in run-time?
 
Not from the object itself. Chip Pearson has a demo on how to get object
properties from the library file:

http://www.cpearson.com/Zips/TLIUtils.ZIP
Download XLTLI - Type Lib Utilities
This download provides about 20 VBA utility functions for working with the
TypeLib Information object library, which is used to read type libraries.
TypeLib Info is the "engine" behind the VBA Object Browser, and this library
gives you programmatic access to type libraries, allowing you to determine
the various arguments for methods, the symbolic names of constants, the
methods of an object and so on. Complete documentation is in the VBA code of
this workbook. This code is for advanced VBA programmers, not novices. An
advanced version of XLTLI is available for commercial customers.

The above is located at his main page
http://www.cpearson.com/excel.htm

--
Regards,
Tom Ogilvy



"Niklas Fjellman" wrote in message
...
Hi
Is it possible in one way or another the get an objects property names in

run-time? In other words I want ta ask the object what properties it have.
Regards
/Niklas





All times are GMT +1. The time now is 03:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com