Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
From
29/07/2002 09:00:51
 
 
To
29/07/2002 08:52:07
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00683467
Message ID:
00683469
Views:
26
I fixed it by moving the cursor into the right cell in the template.



>I have a Excel Spreadsheet with headers and formats but no data.
>
>inVFP I crate a curser then:
>_VFP.DataToClip(,,3)
>
>oE=CREATE("Excel.Application")
>oW=oE.Workbooks.Open("MYTEMPLATE.xls")
>oRange=oe.activeSheet.Range("A7:V7")
>oW.ActiveSheet.Paste
>
>ANd it inserts starting at cell A2 instead of A7 thus overwriting my headers
>
>
>What am I doing wrong???
>
>Thanks
>
>Peter
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform