Save As Overwrite

M

marston.gould

Is there some way to keep the window
that tells me that a file already exists and
do I want to overwrite it from popping up
and let a worksheet save as execute?

give that fStr hold the name of the file


Set wb = ActiveWorkbook
wb.SaveAs (fStr)

is what I have now....but I get the message.
 
N

Norman Jones

Hi Marston.

One way:

Set wb = ActiveWorkbook
Application.DisplayAlerts = False
wb.SaveAs (fStr)
Application.DisplayAlerts = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top