Message Boxes

During the course of a macro, a message box comes up such as "A file already exists by that name, do you want to continue" with two buttons, yes, no. I want the macro to automatically pick "yes" so the macro can continue How would I code this in?

Thanks
ChemistB

hi,

right before you are going to overwrite the file, add this line to your macro
application.displayalerts = false

if you want other possible application messages to be displayed during that macro, set it back to true

Thanks, that seemed to do the trick.

ChemistB