Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Controlling the version of Excel
Message
De
02/05/2013 20:45:29
 
 
À
01/05/2013 18:21:35
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01572404
Message ID:
01572586
Vues:
42
>I think you can use SaveAs rather than Save, but it's been a while since I did Excel automation.
>
>>The client's program uses Office Automation to prepare Excel spreadsheets for email to customers.
>>Some of the client's workstations have the latest Office version and create spreadsheets that cannot be read by earlier versions (I can't read them with Office 2003)
>>Is there some way to control the version that is created ?

It looks as if SaveAs is the answer, but I can't get it to work.
It should accept another parameter for file format.
I found a list, but no matter how I try to pass it, I crash

This is the latest try, and it crashed

ole_xls.ActiveWorkbook.SaveAs(lc_location + pc_detail + ".xls","xlExcel5" )
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform