| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoSave Macro? | Excel Discussion (Misc queries) | |||
| autosave macro excel | Excel Discussion (Misc queries) | |||
| Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
| Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
| Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
Linear Mode
