Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error when trying to open and paste to Excel.
Message
From
20/01/2005 14:25:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Error when trying to open and paste to Excel.
Environment versions
Visual FoxPro:
VFP 6
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00979002
Message ID:
00979002
Views:
57
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
Next
Reply
Map
View

Click here to load this message in the networking platform