Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
Error when trying to open and paste to Excel.
Versions des environnements
I ran into a situation where a particular user is getting errors when trying to "Export to an excel spreadsheet.
Here is the code that is running:
oexcel=CREATEOBJECT("excel.application")
IF VARTYPE(oexcel) != "O"
=MESSAGEBOX("You must Install Excel in order to run this option","Install Excel")
ELSE
SELECT accounts
_vfp.DataToClip(,,3)
oExcel.Workbooks.Add()
oexcel.ActiveSheet.paste
ENDIF
The first error message that appears is OLE error code 0x8002801d: Library not registered.
The second error:OLE IDispatch exception 0 from Microsoft Excel: Unable to get the Paste property of the Worksheet class.
Excel is installed on the machine and after the errors, excel does open but with a blank worksheet. Could the DatatoClip be causing the issue?
Any help would be great.
Thank you
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement