I have written a macro that collects data from dozens of data files into a
single workbook. Every time the macro closes one of the data files I get an
automatic message window that says "There is a large amount of data on the
clipboard. Do you want to save for future applications?" and I must manually
click 'no' dozens of times in this 'automatic' macro.

How do I disable this message window so that it doesn't disrupt my macro?