Set warnings set to no, but won't work when file goes to excel

[tbmarlie]

I've got a macro where, at the end of all the commands, it outputs a
query to an excel file called "SUI Template.xls". Normally, the user
will then save the template to the name of another file. But, if they
didn't save it from the previous time, the issue is that it always
prompts with an access dialogue box asking if I want to replace the
existing SUI Template.xls. Why does it do this if I have the Set
Warnings condition to "No". Is there a was to control this with some
vb code so that it automatically replaces the file?

 

[taxidev]

Don't use a macro, use the common dialog instead.