I have a macro in Access that exports 4 tables to xlsx spreadsheets. I use "SetWarnings No" to turn off all warnings when running queries, etc...
but this does not work to turn off "Do you want to replace the existing file?" when tables are output to excel to replace existing tables.
I am writing out 4 tables to Excel spreadsheets, and that requires saying "Yes", 4 times.
How can I turn this off to save time?