Macros and large clipboard error

[Sarahds]

I have written a macro that copies info from 10 other workbooks an
pastes that into one workbook (consolidating, but including th
individual worksheets). In the macro, I close each workbook afte
doing the copying and pasting and click on the "No" when I get th
question "do I want to keep the large amount in the clipboard".
However, when I run the macro, it stops at that point until I have don
a manual click and then continues. How can I automate this?

Sara

 

[Tom Ogilvy]

before you get to that point

Application.CutCopyMode = False

clears the clipboard.

or

Application.Displayalerts = False
' code the closes the workbook
Application.DisplayAlerts = True

 

[Sarahds]

Thanks for the info Tom