| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save Macro Question
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Save Question | Excel Worksheet Functions | |||
| Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
| Save Macro - yet another question | Excel Discussion (Misc queries) | |||
| Prompted to save changes after macro save - why? | Excel Programming | |||
| A save question: | Excel Programming | |||
Linear Mode
