Save Macro Question

  • Thread starter Thread starter blewyn
  • Start date Start date
B

blewyn

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
 
One way:

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileFormat:=xlWorkbookNormal
Application.DisplayAlerts = False
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lose macros before saving 4
macro free workbook saves macro 0
Anyone Know Workbook Openening & Saving Macro Alternatives? 2
How can we convert OST to PDF file format? 1
CommonButton was out of function since Dec 2014 6
How to Export Gmail Emails to PST Format? 4
Auto run macro when file is saved 1
Want Macro to save to .xlsx 2

Back
Top