File Saving

[austin350s10]

I am using a script to save the active workbook only thing is when the user already has the workbook saved with the same name excel asks them if they want to replace it or not.

If the user clicks the cancel button an error screen pops up

Is there a way avoid the error screen or better yet is there a way to force excel to overwrite a file name if it already exists?

 

[Peter_SSs]

You may need to post your existing code, but see if this would help

Application.DisplayAlerts = False

'Put your code to do the SaveAs here

Application.DisplayAlerts = True

 

[austin350s10]

perfect....I always wondered what that met....Thanks!!!