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
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