i have a macro that opens numerous excel spreadsheets in an array an
pastes data into sheets in a master document. after each paste th
source spreadsheet is closed, then the loop begins again by opening th
next spreadsheet in the array.

the problem i have is the message stating that "there is a large amoun
of data still on the clipboard etc.." when each source spreadsheet i
closed. This requires me to manually select "NO" at the end of ever
loop, to inform Excel that i do not need this data to be stored fo
future use (as i have already pasted it).

is there a way of disabling this, or coding something in the macro t
automatically select "NO" when prompted by the clipboard message.

any ideas welcomed

--
presuming e
-----------------------------------------------------------------------
presuming ed's Profile: http://www.excelforum.com/member.php...fo&userid=3152
View this thread: http://www.excelforum.com/showthread.php?threadid=51219