Macro SetWarnings (Access 2003) not working

[JellyShredder]

I've seen the answer in this community but they don't seem to work. Am I
missing something?
Access 2003
My macro runs a Beep; Message; SetWarnings "No"; OutputTo Excel (to
overwrite existing file of same name); there are 20 lines of "OutputTo" for
each different query; SetWarnings "Yes"; Beep; Message.
I still get prompted 20 times "Yes/No" to overwrite.
Thanks in advance :^)

 

[Ken Snell \(MVP\)]

SetWarnings does not apply to overwriting an EXCEL file.

 

[JellyShredder]

Thanks Ken.
Much appreciated.

SetWarnings does not apply to overwriting an EXCEL file.