Save As in VB

[davidhall80]

I am trying to save a file over an older file with the same name. Everytime I get to that part in the macro, I get prompted by excel whether I want to save over the other file. My answers is always YES. is there a way for excel VB to choose YES for me. Thanks in advance

 

[Smitty]

Application.DisplayAlerts = False will suppress that message.

Just set it back to True at the end.

HTH,

Smitty

 

[davidhall80]

Do I have to paste that code after each save I do in my macro or just one time in the beggining

 

[Smitty]

Once at the beginning and once at the end.

Smitty