Clear Clipboard programmatically

Valica · #1 (**permalink**) 04-10-06, 06:14

Hello everybody!

Valica · #2 (**permalink**) 04-10-06, 06:14

Does anyone know how can I clear the Office clipboard from VBA?

Fazza · #3 (**permalink**) 05-02-06, 04:09

I just googled and found this. Cheers, Fazza

Code:

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

Internet Services

Web Development

Digital Marketing

Consumer Tech