MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Does anyone know how to “save as” without error messages.

Posted by Andy on May 09, 2001 10:51 AM

With a macro, I am trying to open a file and then “Save as” another file.
I have mastered this step but I keep getting a user interface box telling me the file already exists.
I know it does! I created it a few hours ago.
Is there any way of suppressing the error box whilst running the macro; so that no user input is required, apart from setting the macro in operation.


Posted by Dave Hawley on May 09, 2001 10:53 AM

Hi Andy

There sure is, use:

Sub YourMacro()
'Your code
End sub


OzGrid Business Applications

Posted by Andy on May 09, 2001 11:00 AM

Thanks Dave, off down the Pub now, I'll have a beer for you!

Cheers mate!!