Err
Active Member
- Joined
- Nov 16, 2006
- Messages
- 274
Hi,
This code saves a copy of a workbook and it works fine
My issue is this message:
Can I either remove this message or change it to something like "Preparing Email"? Rather than "Saving As"
Thanks
This code saves a copy of a workbook and it works fine
Code:
Application.DisplayAlerts = False
orig_wb.SaveAs Filename:="F:\EmailFile.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
Application.DisplayAlerts = True
My issue is this message:
Can I either remove this message or change it to something like "Preparing Email"? Rather than "Saving As"
Thanks