Code to answer No to an error message

[boohah]

Hi

I have a macro enable spreadsheet (Book1.xlsm) and one of its functions is to copy data from a second spreasheet (Book2.xlsx) and copy it into the original spreasheet (Book1.xlsm). Everything works fine if Book2 is closed when i run the macro but if it is already open I get the following message:

"Book2.xlsx is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen Book1.xlsx" [Yes] [No]

The code in use is large and complicated so I haven't pasted it in this forum. All I need is a single line of code that answers No to the above error message.

Any help would be appreciated.

Doug