Automating responses to Message Boxes in Visual Basic

[Nigel Smith]

I am writing a macro that opens a specified file and
temporarily places data in it. I want to be able to
automatically close the file without saving the changes.

At present, when the Macro reaches the
activeworkbook.close function, Excel effectively "jumps
out" of the Macro until the user responds Yes/No/Cancel to
the "Save Changes" message box, at which point the macro
continues.

Is there anyway of automating this response?

 

[Don Guillett]

answered elsewhere