G Guest Mar 15, 2007 #1 Is there a way to clear the office clipboard using VBA. I am making some large copies in a macro and it eventually freezes my system.
Is there a way to clear the office clipboard using VBA. I am making some large copies in a macro and it eventually freezes my system.
G Gord Dibben Mar 15, 2007 #2 Larry Application.CutCopyMode = False clears the clipboard. Plunk it into your macro after your paste code. Gord Dibben MS Excel MVP
Larry Application.CutCopyMode = False clears the clipboard. Plunk it into your macro after your paste code. Gord Dibben MS Excel MVP
G Guest Mar 16, 2007 #3 Thanks for your reply. I have tried that and it isn't clearing the clipboard. Could I have sometning in the setup that prevents this.
Thanks for your reply. I have tried that and it isn't clearing the clipboard. Could I have sometning in the setup that prevents this.
G Gord Dibben Mar 17, 2007 #4 Larry If you're still there, try this...... Sub ClearClipboard() OpenClipboard 0& EmptyClipboard CloseClipboard End Sub Gord
Larry If you're still there, try this...... Sub ClearClipboard() OpenClipboard 0& EmptyClipboard CloseClipboard End Sub Gord
