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 |
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 |
All times are GMT +1. The time now is 09:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com