Access Macro - Need to suppress overwrite messages
Posted on 2016-10-27
I have a Macro in Access 2013, it exports results to excel files, I have setup a template, it overwrites the existing files
I have set warnings set to No.
However, it keeps asking about overwriting the file, is there a way to stop this and do it automatically. I need to do it this way as I have one excel file that has references to all the other excel files (collating the results), which have been exported from Access.