Macro should autosave

J

Jon Dibble

Hi
I have macro that manipluates a file then should autosave. But when I run it
asks if I want to save changes even though I have specified it ignores in my
code below? Would appreciate any help.

Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="Y:\bcms_1002.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Application.DisplayAlerts = True
 

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

45 seconds to save a file, why so long? 1
Creating Path and FileName 2
Code Fails on SAVE 4
Saving a workbook to an iKnow portal 2
Macro to save 2007 file in 97-2003 format 2
'Save as' dialog opens despite Application.DisplayAlerts = False 6
File SaveAs 4
Save as marco 3

Top