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