Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel constants
Message
From
19/07/1999 18:55:44
 
 
To
19/07/1999 10:42:36
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00242657
Message ID:
00243341
Views:
20
For future reference, Rick Strahl has written a utility that extracts all constant names and values and creates an include file from a dll or a tlb. That way, you aren't SOL if you can't file help for a particular COM server. It is in te files section here, search for "constants".

>Thanks for you replies. It was very helpful. Most help files take care of making it all clear, or, at least take you to places which explain any extra information, there aren’t any direct links to constants from within the Excel/VB help. These constants are kind of hidden and never available first time for any entrepreneur looking for how to automate Excel. I just wonder why.
>
>Regards
>
>Oscar
>
>>It is important to note that there *is* documentation on this that does ship with the product. If you go into the Visual Basic Editor in Excel, press F2 to display the object browser, you can then search on the constant name to find the value. Dave's solution is nice because you get them in one shot.
>>
>>Another good resource is the Office SDK
>>
>>
>>>Is there a file included with Excel with a list an/or descriptions of these constants? I know that there is a constants file at the files section but I’d like to find some more information about this constants.
>>>
>>>Thanks in advance
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform