View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
blewyn blewyn is offline
external usenet poster
 
Posts: 2
Default Save Macro Question

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