Deleting the clipboard contents!!!
Posted by SWallace on December 20, 2001 4:34 AM
Here's my problem. I've gotten together a really useful Macro to open all workbooks in a dir and copy out the relevant cells pasting them in succession into
the new workbook so I can work with the figures there.
however when I get the macro to close files when its finished I get the message box " there is a large amount of info on the clipboard......" after each file is sent the close command , which stops the macro until the box is clicked. Does anyone know how I can prevent this ?
Cheers in advance