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

[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!

 

[Ed]

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

Ed

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!


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements