Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copy TO XLS
Message
De
10/01/2006 17:10:45
 
 
À
09/01/2006 16:30:08
Fred Wood
Madera Systems Consulting
Mill Valley, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows 2000
Database:
Visual FoxPro
Divers
Thread ID:
01084953
Message ID:
01085405
Vues:
13
Fred,

There seems to be an issue with ActiveSheet.saveAs() under Excel2003. As Cetin suggested, the workaround is to use ActiveWorkbook.saveAs() instead.

I have adjusted the FAQ article accordingly.

Hope this helps.

Daniel

>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
Daniel
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform