Disable Dialogue Box To Save & Replace File
 

Hi,

I'd like to have a macro to NOT have excel ask me if I want to replace the
existing file when i save, ie, when I save a file and there's already one in
the folder, I want excel to just overwrite the file without having a dialogue
box asking me if I want to overwrite the existing file. Is it possible?

Regards,
Dolphin

Disable Dialogue Box To Save & Replace File
 

Hi, Fish. :) Dave Hawley has an article he
http://www.ozgrid.com/VBA/prevent-save-prompt.htm
************
Anne Troy
www.OfficeArticles.com

"Dolphinv4" wrote in message
...
Hi,

I'd like to have a macro to NOT have excel ask me if I want to replace the
existing file when i save, ie, when I save a file and there's already one
in
the folder, I want excel to just overwrite the file without having a
dialogue
box asking me if I want to overwrite the existing file. Is it possible?

Regards,
Dolphin

Disable Dialogue Box To Save & Replace File
 

Dolphin

Try

Application.DisplayAlerts = False
save file
Application.DisplayAlerts = True


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=478670