Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel Automation
Message
From
29/07/2002 09:06:14
 
 
To
29/07/2002 09:05:00
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00683467
Message ID:
00683474
Views:
22
Whoops!! Then change the oW.ActiveSheet.Paste line to read oRange.Paste.

Alan

>Probably better to do it in code. After the 'oRange=' line, add a line: oRange.Select()
>
>Alan
>
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform