Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clipboard
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Store clipboard before "vba do cut&paste" then recover stored information to clipboard? | Excel Programming | |||
ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard? | Excel Programming |