Thread: Close a workbook without saving

Good afternoon,

I have a macro that I recorded that will allow me to open an excel file "Money.xls" copy the worksheet "Mort" from that file to open excel file "Savings.xls" on the worksheet "raw data" then close that file. The issue is that when it closes the Money.xls without saving it is asking me if I want to store the copied data for future use. I have to click no before the Macro can continue to do other things. How do I stop this? I dont want to keep clicking no each time I run this Macro. Any assistance is greatly appreciated.

That's what I thought but couldn't type it as well as you did. Thanks Tom.