Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
i have workbook a to m, and x
i wrote a macro using vb to... open workbook a, then copy information from workbook a to workbook x, close workbook a, then repeat the procedure for all workbooks. but due to the amount of data that every workbooks has, the windows dialog box will said something like 'do you want to empty the clipboard' when it's trying to close the workbook. how to i automate this so it will empty the clipboard before it closes the file. thx. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot empty the clipboard | Excel Discussion (Misc queries) | |||
Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
macro help - closing without saving & empty clipboard | Excel Discussion (Misc queries) | |||
"Cannot empty Clipboard" | Excel Worksheet Functions |