Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy TO XLS
Message
 
 
To
09/01/2006 16:30:08
Fred Wood
Madera Systems Consulting
Mill Valley, California, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows 2000
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01084953
Message ID:
01084958
Views:
15
>I am trying to use code created by Daniel Gramunt I found here on the Unvervsal Thread to compensate for the VFP limitation of max. 16383 records in COPY TO TYPE XL5 and although it has worked for me before in other situations, I am now getting an OLE error - Unknown COM status code when Excell is instructed to save the new worksheet.
>
> loXLS.ActiveSheet.saveAs(tcExcelFile, xlWorkbookNormal)
>
>Could anyone give me a hint as to how tom begin to debug this?
>
>
>Thanks

Send Daniel an e-mail? <g> That would be my course of action, I guess, if I would not be able to figure this our in a relatively short time. <g>

UPDATE. Ok, I sent him a note <g>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform