eliminating a message box??? thanks

[q4s72534]

I’m getting a message box that says “do you want to replace an existing file?” when I save an active worksheet using vb script.

ActiveWorkbook.Save

How can I eliminate that message box question?? thanks

 

[ribhead]

Hey there G.

How about trying the Application.DisplayAlerts=False?

Just a thought.

For just $19.95 you too can have a beautiful smile.

 

[vaneagle]

Hi,

Not sure which version of excel you are using, but if you are using excel 97 you will need to turn it back on again...

 Application.DisplayAlerts = true

Regards,

Paul