thistle
06-25-2013, 07:10 AM
I have a workbook that I open in Outlook containing some information I need. My VBA code in Outlook modifies some cells in the workbook, saves and closes it.
It does the job, but when I save (using Workbook.SaveAsI get a dialog saying that the file exists and do I want to overwrite. I get the same dialog if I use Workbook.Save
I want to stop this dialog coming up. In Excel I would use Application.DisplayAlerts = False but this isn't available in Outlook.
Can anybody tell me how to suppress this dialog in Outlook?
It does the job, but when I save (using Workbook.SaveAsI get a dialog saying that the file exists and do I want to overwrite. I get the same dialog if I use Workbook.Save
I want to stop this dialog coming up. In Excel I would use Application.DisplayAlerts = False but this isn't available in Outlook.
Can anybody tell me how to suppress this dialog in Outlook?