>>Hi all,
>>
>>Where can I find a complete obect model for MS Excel? I like to manipulate
>>Excel from within VFP like opening an existing spreading sheet, retrieving
>>cells' value and etc...
>>
>>Or anybody can give a few pinters to get me started ?
>>
>>Thanks.
>>
>>Kam.
>
>What I usually do is save a macro in Excel, for whatever I plan to do (say, bold, borders, change column width, etc.). The commands can then easily be adapted to VFP.
>
>The following primitive sample may help you get started:
>
>
>oExcel = CreateObject("Excel.Application")
>oExcel.Visible = 1
>oExcel.Workbooks.Add()
>oSheet = oExcel.ActiveSheet
>oSheet.Cells(1,1) = "Hello!"
>
>
>Afterwards, use the "macro" approach.
>
>HTH, Hilmar.
Hi Hilmar,
Thanks for the tip. By any chance you know how to open an existing Excel
worksheet ?
Thanks again.
Kam.