File already exists
 

Use:

Application.DisplayAlerts = False

at the beginning of the code to suspend Excel from displaying any type of
alerts while executing the macro. Use:

Application.DisplayAlerts = True

at the end of your code to reinstate the display of alerts.

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

"Bob" wrote in message
...
Hi
How can I bypass "File already exists would you like to overwrite" and
save file over old file?

Thanks
Bob