How do I close a workbook witout saving changes

HI,

I am running a macro that is opening and merging a number of spreadsheets, merging data etc. when I then go to close the unwanted files I get a message, "would you like to saves the cahnges made... "

Is there a way to close the files automatically without saving?

Thanks

Originally Posted by plunkettyplunk

HI,

I am running a macro that is opening and merging a number of spreadsheets, merging data etc. when I then go to close the unwanted files I get a message, "would you like to saves the cahnges made... "

Is there a way to close the files automatically without saving?

Thanks

Application.DisplayAlerts = False

should probably work