Excel: Clearing Clipboard in Excel 2013 VBA


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? [I]Option Explicit[/I] [I]Public Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long[/I] [I]Public Declare Function EmptyClipboard Lib "user32" () As Long[/I] [I]Public Declare Function CloseClipboard Lib "user32" () As Long[/I] [I]Public Function ClearClipboard()[/I] [I] OpenClipboard (0&)[/I] [I] EmptyClipboard[/I] [I] CloseClipboard[/I] [I]End Function[/I] [I]Sub Test()[/I] [I] Call ClearClipboard[/I] [I]End Sub[/I] regards, melson


This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of April 15, 2014.


For more resources for Microsoft Excel