Application.thisworkbook.saveas .. Is there a way to bypass "Overwrite" popup?

K

kenji4861

I do a "application.thisworkbook.saveas" everytime to a different
location, and sometime even on the same file.

When I hit the same file, is there a way to make it so the "Overwrite"
popup does not show up? Thanks!
 
E

Ed

You might try putting Application.DisplayAlerts = False just before your
..SaveAs command, then reset to Application.DisplayAlerts = True afterwards.

Ed

kenji4861 said:
I do a "application.thisworkbook.saveas" everytime to a different
location, and sometime even on the same file.

When I hit the same file, is there a way to make it so the "Overwrite"
popup does not show up? Thanks!
Click to expand...
creating financial statements
 
Top