Ok here is the situation: I have an Autoexec macro that does the following in order
1) Runs a set of queries(1-9)
2) Exports the final query to excel
3) Does some formatting (subtotals etc)
4) Saves the changes in excel
5) Emails the excel file
The problem is that when it saves the changes in excel (4) the process stops because excel warns that the file already exists. How do I stop this from happening? I know access DoCmd.SetWarnings False / true but that wont stop the warnings in excel
| 
