Help or Information about Microsfot Excel Aplication Objet model

[Alonso Vilela]

Now I know how create object (VFP) and do something but I want more
information about object tree and sintax or Examples.

I now most common object are:

oxl = createobjet("Excel.application")

oxl.application
oxl.workbooks.
oxl.Sheets.

Thanks

 

[Guest]

You are missing the heirarchy of the objects. The syntax you provided will
not work. The application contains workbooks which in turn contain worksheets
which in turn contain ranges. So you need something more like

oxl.workbooks("Mybook").Worksheets("MySheet").Range("A1")

You can not get to the range directly without specifying the book and sheet.
the same is true of the sheet. You can not have

oxl.worksheet

because you have not specified the book.