>>>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.
>
>Ed- you can check all these in the Excel VBA editor's object browser. In Excel, go to Tools,Macros, VBA Editor. Once in the editor, press F2 to bring up he object browser. Now, just type in the name of the constant (or function, or property, or object) in the search window and look at its value in the bottom of the browser.

Got it. Thank You.