Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.vb.general.discussion,microsoft.public.vb.syntax,microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List of property names and values for a given object. MichaelMalone Excel Worksheet Functions 0 September 16th 05 09:49 PM
Run-time error '1004' - Unable to set the Visible property of the Worksheet class Shalin Chopra Excel Programming 3 November 25th 03 08:38 PM
Run-time error '1004' running to excel objects at once Dianna Braden Excel Programming 0 October 16th 03 08:55 PM
Sort names into another worksheet by a property Ron Mello Excel Programming 2 September 30th 03 01:41 PM


All times are GMT +1. The time now is 12:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"