Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.vb.general.discussion,microsoft.public.vb.syntax,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List of property names and values for a given object. | Excel Worksheet Functions | |||
Run-time error '1004' - Unable to set the Visible property of the Worksheet class | Excel Programming | |||
Run-time error '1004' running to excel objects at once | Excel Programming | |||
Sort names into another worksheet by a property | Excel Programming |