Stopping "Do you want to overwrite ?" warning

[timffm99]

I am writing a macro to open a file over the weekend whilst the office is empty. It will change a file, save it and email out the result.

When the macro saves, the warning comes up telling me that the file already exists, do I want to over write it. Unless I hit the yes button everything stops.

How do I stop this happening, so the file will save and can be emailed out

Thanks

 

[Richie(UK)]

Hi tim,

Try

Application.DisplayAlerts=False
'
'your code
'
Application.DisplayAlerts=True

HTH

 

[phantom1975]

The other alternative would be to use the SAVE function instead of the SAVEAS function.