One way:

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileFormat:=xlWorkbookNormal
Application.DisplayAlerts = False


In article ,
(blewyn) wrote:

Hi,

I'd like a macro to save my worksheet without any user input. The
worksheet original is in Excel 2.1 format, and we use Excel2000, so
every time it runs the user is presented with a popup window asking if
he/she wants the file saved as 2.1 or latest format (it's "YES" for
the latest format). How do I get the :

ActiveWorkbook.Save

statement to save as latest format automatically, without needing any
user input ?

Cheers,

Blewyn