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:
01611990
Vues:
75
>>>
>>>oXL = CreateObject("Excel.Application")
>>>oXL.Workbooks.Open("YourFile.XLS")
>>>oXL.ActiveWorkbook.Save("YourFile", nDesiredFormat)
>>>oXL.Quit()
>>
>>
>>>
>>>
>>>Use 56 for Excel 97 format. That said, I don't think newer versions can actually produce an Excel 97 format that VFP can read. You have to go back to Excel 5 format for that to work; I think the constant you want is 39.
>>>
>>>Tamar
>>
>>
>>Tamar
>>
>>I don't understand - the file I am trying to convert is an xslx file to xls file - will your code do that?
>
>It should - just use xlsx as extension in the sample. Why you don't want to try that code first to test?

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()
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform