Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel 2010 Automation issue with workbook object
Message
De
10/12/2013 07:11:57
 
 
À
10/12/2013 07:02:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01589653
Message ID:
01589656
Vues:
50
Thierry

Thanks - that worked for the client's W7 machine ...... but not for the W8 ! - both running Excel 2010. I will investigate a bit more.... and might be back for more help in due course.

Thanks for assistance so far.

Barry

>what about
>
>COPY TO C:\myfolder\mysheet.XLS TYPE XL5 && XL5 instead of XLS
>
>
>>I have a small Excel automation program that generates a data set in VFP and then copies the data to an Excel spreadsheet. I than create a workbook object and add a chart to it.
>>
>>COPY TO C:\myfolder\mysheet.XLS TYPE XLS
>>oWorkBook = GETOBJECT("C:\myfolder\mysheet.xls")
>>oChart1=oWorkBook.Charts.Add()	
>>
>>This works fine in Excel 2003 (on XP) but crashes in Excel 2010 (on a W7 OS) on the 3rd line with Error message: Object OWORKBOOK is not found.
>>
>>Any help appreciated.
>>
>>Barry Sutton
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform