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
Posted by paul on December 20, 2001 4:44 AM
Heres a possible solution:
Just finish off the macro with a command that tells it to copy a single charachter to the clip board stored in a cell e.g. put a letter x in a cell out of the way somewhere and finish the macro with
Range("yourcell").Select
Selection.Copy
That way it won't think it's got a large content??
Posted by Apemantus on December 20, 2001 6:16 AM
Application.CutCopyMode=False
Posted by Mark O'Brien on December 20, 2001 9:41 AM
You could put this code before the macro:
Application.DisplayAlerts = False
Posted by Diomedes on December 20, 2001 3:27 PM
Hmmm ....... here is the complete revelation ......
All is revealed at MS Knowledge Base (Article #Q287392) :-
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q287392
