Clearing clipboard with VBA

Hi guys

Hopefully an easy one: Is there a way of clearing the Windows clipboard using VBA?

I've got some code that places large amounts of data on the clipboard, and I seem to be having memory problems. If I could clear the data mid-code, I think the problem should resolve.

Please tell me it's a simple line in VBA!

Any help appreciated, thanks

Nick

Put this code in a module:

Option Explicit
Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Public Declare Function EmptyClipboard Lib "user32" () As Long
Public Declare Function CloseClipboard Lib "user32" () As Long

Public Sub ClearClipboard()
    OpenClipboard (0&)
    EmptyClipboard
    CloseClipboard
End Sub

To clear clipboard put the code:

Call ClearClipboard

in your sub

Regards,
Antonio

Excellent! Thanks very much.

Nick