melson titular
New Member
- Joined
- Oct 3, 2013
- Messages
- 43
Hello guys.,
i have found this code and tried it out.,
upon checking., it seems it is applicable only for 2004 and below excel versions.
is there other way to clear the clipboard in excel 2013?
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 Function ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
End Function
Sub Test()
Call ClearClipboard
End Sub
regards, melson
i have found this code and tried it out.,
upon checking., it seems it is applicable only for 2004 and below excel versions.
is there other way to clear the clipboard in excel 2013?
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 Function ClearClipboard()
OpenClipboard (0&)
EmptyClipboard
CloseClipboard
End Function
Sub Test()
Call ClearClipboard
End Sub
regards, melson