Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help or Information about Microsfot Excel Aplication Objet model
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 a oxl = createobjet("Excel.application") oxl.application oxl.workbooks. oxl.Sheets. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help or Information about Microsfot Excel Aplication Objet model
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").Rang e("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. -- HTH... Jim Thomlinson "Alonso Vilela" wrote: 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 a oxl = createobjet("Excel.application") oxl.application oxl.workbooks. oxl.Sheets. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aplication to import and Convert Data | Excel Programming | |||
Reading excel data into another aplication | Excel Programming | |||
How do I open an aplication and run a file in that aplication use. | Excel Programming | |||
Dictionary objet | Excel Programming | |||
VBA Excel objet indexed | Excel Programming |