Turn Off Warnings to Overwrite "ExportWithFormatting"

[RogerD]

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?

[RAshA.pro777]

If you use set warning in the first line it will work and hide all warnings ,
And you should to enable all macro in trust center or add the partition which include your work in the trusted locations

[CJ_London]

the warning you are getting is not an access warning but a windows explorer one so setwarnings won't work

what you need to do is modify your code to check for the existence of the file and delete it if it exists

you can just try to delete the file whether it exists or not - if it doesn't exist a vba error will be generated which can be 'ignored' by putting 'on error resume next' just before the delete line and 'on error goto 0' just after - or better to handle within an error handler