Information générale
Catégorie:
Codage, syntaxe et commandes
Hi, Jeff.
This from the SaveAs VBA syntax for Excel:
expression.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended,CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodePage, TextVisualLayout)
From the FileFormat VBA syntax for Excel:
FileFormat Property
Applies To
Workbook object.
Description
Returns the file format and/or type of the workbook. Read-only Long
So, I suggest getting the fileformat of a ver 5 workbook you open so you know what the numeric equivelent of the Excel constant is, and then use that value in your saveas command.
hth
>I've got an Excel OLE automation that opens a ver 5 workbook does some stuff and then saves it as the same file name. My problem is that I've got excel ver 7 doing the automation and a lot of users have ver 5.
>
>How do I get the file to save as ver 5.
>
>ox.ActiveWorkbook.SAVEAS("c:\myworkbook.XLS",1)
>
>TIA
>Jeff
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement