Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xslx
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Re: Xslx
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01611889
Message ID:
01612042
Vues:
84
>>>This is my VFP code - comes up with unrecognised command verb on first line - what am I doing wrong?
>>>
>>>
>>>oXL = CreateObject("Excel.Application")
>>>oXL.Workbooks.Open("c:\aatemp\global.XLSX")
>>>oXL.ActiveWorkbook.Save("c:\aatemp\globalnew.xls", 56)
>>>oXL.Quit()
>>>
>>
>>Do you have Excel installed? What is the version?
>>
>>I just tested this code
>>
>>
>>oXL = CreateObject("Excel.Application")
>>oXL.Workbooks.Open(GETFILE('xlsx'))
>>*oXL.ActiveWorkbook.Save("c:\aatemp\globalnew.xls", 56)
>>oXL.Quit()
>>
>>worked fine for me, no errors.
>
>do I need to have the latest version of Excel installed ie the one that can read xslx files

Yes, I believe you need to have the version that can open xlsx files for this code to work.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform