>>>Thanks - I was unable to download the Excel constants though - I believe that is the piece I've been missing. It's been hit or miss with the modifications to the charts to date. It's working - just not quite as well as I need right now. I'll keep plugging away.
>>>
>>>Happy New Year!
>>
>>Pardon me for jumping in, but you can find the constants using the Object Browser. Open it and, under COM libraries find Microsoft Excel.
>Does this work on Visual FoxPro 6? I tried to open a file with OLB extension, but could only see constant names; not the corresponding values. Do I need a newer version of Visual FoxPro, or perhaps I have to open a file with another extension?
>Thanks in advance, Hilmar.
Object Browser is available in VFP7, but you can use the Object Browser provided by Visual Basic 6, I don't know if you can extract Constants with them. Anyway, with VFP7 you can create an .H file with constants like this:
1.- Open Object Browser: Tools -> Object Browser
2.- Access to the COM library
3.- Check the ActiveX/COM Library to access PEMs (Propierties, Events, Methods) y constants.
4.- Select the Constast section.
5.- Hacer Drag & Drop sobre editor de VFP (but you can do it with any editor).