How do I write my Excel 2000 macro to automatically answer the following question "YES"? "There is a large amount of information on the Clipboard. Do you want to be able to paste this information into another program?" Yes/No/Cancel are choices.
This pops up whenever I try to close one spreadsheet (csv file) after I have copied its entire contents to the clipboard for pasting into another spreadsheet.