Clearing the clipboard

**Kevlar** · 11-22-2006, 04:09 PM

Is there a way to clear the contents of the clipboard programatically?

**VBA Noob** · 11-22-2006, 04:15 PM

Hi,

Does this code work

application.cutcopymode=false

VBA Noov

**dominicb** · 11-22-2006, 05:50 PM

Hi VBA Noob

The CutCopyMode=False just removes the "marching ants". As the clipboard is a Windows object you need API's to clear it effectively.

Declare Function CloseClipboard Lib "user32" () As Long
Declare Function EmptyClipboard Lib "user32" () As Long
Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Sub ClearClipboard()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub

Calling the macro ClearClipboard should do just that.

HTH

DominicB