Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xslx
Message
De
09/12/2014 05:57:18
 
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:
01612030
Vues:
73
>>>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, of course. However, it's possible that Microsoft has a free utility to open xlsx files in earlier versions, just like they have for Word. Whether it will work for you, I really don't know.

Update: you will find the "Compatibility Pack" here: http://www.microsoft.com/en-us/download/details.aspx?id=3
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform