Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel - Unable to get Paste property of Worksheet class
Message
From
01/06/2001 15:14:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel - Unable to get Paste property of Worksheet class
Miscellaneous
Thread ID:
00513987
Message ID:
00513987
Views:
857
The following code works without any issue in a regular VFP Class:

SELECT c_sum2
GO TOP
Application.DataToClip(,,3) && copy data to clipboard delimited with tabs
USE IN c_sum2
This.oExcel.Range("A1").Select()
This.oExcel.ActiveSheet.Paste()

However the last line [.ActiveSheet.Paste()] creates the following
error when I run this thru a registered DLL:

Error in line 161 OLE IDispatch exception code 0 from Microsoft Excel:
Unable to get the Paste property of the Worksheet class.. 429

Any ideas on how this can be resolved? I tried both application.datatoclip()
and the _CLIPTEXT = FILETOSTR(file) techniques to no avail
Next
Reply
Map
View

Click here to load this message in the networking platform