office clipboard
 

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.

office clipboard
 

Larry

Application.CutCopyMode = False

clears the clipboard.

Plunk it into your macro after your paste code.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 11:03:18 -0700, Larry
wrote:

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.

office clipboard
 

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.

"Gord Dibben" wrote:

Larry

Application.CutCopyMode = False

clears the clipboard.

Plunk it into your macro after your paste code.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 11:03:18 -0700, Larry
wrote:

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.

office clipboard
 

Larry

If you're still there, try this......

Sub ClearClipboard()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub


Gord

On Thu, 15 Mar 2007 18:09:00 -0700, Larry
wrote:

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.

"Gord Dibben" wrote:

Larry

Application.CutCopyMode = False

clears the clipboard.

Plunk it into your macro after your paste code.


Gord Dibben MS Excel MVP

On Thu, 15 Mar 2007 11:03:18 -0700, Larry
wrote:

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.