Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
 
To
20/01/2004 22:10:59
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00868829
Message ID:
00869022
Views:
11
>oExcel = CREATEOBJECT('Excel.Application') will create an Excel object, but how to I find out the possible command to use with that object.
>
>I have seen a few, but I how do I find a list of all or some type of documentation.
>
>For example
>oExcel.Workbooks.Add
>oExcel.ActiveSheet.RANGE('A1').SELECT
>oExcel.ActiveSheet.Paste()
>oExcel.visible = .T.
>
>How do I insert a new top row into an existing XLS and populate one cell of that new row?

In addition to Jos's advice - a lot of us (and the articles will probably bare this out) use the macro record feature and the paste code from the macro editor into our apps and edit to work with VFP.
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform