ExcelBanter - Macro should autosave

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Macro should autosave (https://www.excelbanter.com/excel-programming/422311-macro-should-autosave.html)

Jon Dibble

Macro should autosave

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

All times are GMT +1. The time now is 12:56 PM.