Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does any know where to find excel constants
Message
From
15/07/1999 22:34:30
 
 
To
15/07/1999 21:10:08
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00242101
Message ID:
00242133
Views:
23
>Hi,
>I'm writing a simple program that creates a worksheet. I would like to add some simple formating (like cell background colors and lines). However, when I check the VBA information they make references to constants like "xlthinline" or "xlmeduimline" (anyway some thing close to those names) and they refer to some constant assigned to a property value. I'm sure it works in VBA but when I use the name in VFP is does not see it as a constant value but a variable. So I need some thing like a "EXCEL.H" file. So does anybody know where to find the file or something like it.
>TIA
>John

I tried, but ended up with a 'workaround'. Open Excel through OLE Automation, right from Command Window. Now create what you want to use later in Excel manually, and check from VFP command window what values return some Excel properties/methods. Gradually, you will figure out what actual values hidden behind this constants.
That's quite unacceptable that Help does not have a list of them.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform