>>>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!
>>
>>PMFJI, but you can find the constants using the Object Browser. Open it and, under COM libraries find Microsoft Excel.
>
>Does this work on VFP 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 VFP, or perhaps I have to open a file with another extension?
>
Hilmar,
I was referring to the Object Browser which started with 7.0. The Class Browser requires you to know the exact name of the file containing the information. However, you don't need VFP 7.0. Go into Excel and select Visual Basic Editor. It has an Object Browser that'll show you the constants.
George
Ubi caritas et amor, deus ibi est