Solved: Suppressing a message box

[infinity]

Hey VBaxers,

I have got code that saves my workbook to an external hard drive as a backup. Everytime I run this code I get a ballon that says this "file already exists, do you want to replace it?" Is there any way of suppressing this message only when I run this code? I will always want to replace the file and would rather not have to tell it "Yes" everytime. Thanx, ya'all!

Scott

[shasur]

' Do not Show the Alerts from Excel

Application.DisplayAlerts = False

'' do your saving here

'Now reset
Application.DisplayAlerts = True

[infinity]

shasur,

Thank you, thank you! I knew there was a simple way of doing it and I thought I had done it before with a different workbook but I could not find it. Thanx again.