Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel - Unable to get Paste property of Worksheet class
Message
De
01/06/2001 15:14:35
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel - Unable to get Paste property of Worksheet class
Divers
Thread ID:
00513987
Message ID:
00513987
Vues:
858
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform