Hi,

I'm writing a macro that opens an Excel version 3 file,
changes it and then saves it.

Normally when you change an older version Excel file, you
get a prompt asking you if you want to update the file to
the new excel (in my case Excel 97) or leave it in the
current format.

How do you control this from within VBA, so you can decide
when it should update the file and when not.

Help appreciated.

Dell

use the fileformat argument to the SaveAs method of the workbook object.

--
Regards,
Tom Ogilvy


"Dell" wrote in message
...
Hi,

I'm writing a macro that opens an Excel version 3 file,
changes it and then saves it.

Normally when you change an older version Excel file, you
get a prompt asking you if you want to update the file to
the new excel (in my case Excel 97) or leave it in the
current format.

How do you control this from within VBA, so you can decide
when it should update the file and when not.

Help appreciated.

Dell