>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
