Clearing the clipboard

[Avi]

Hello,

I'm looking for some API or othe method for clearing the clipboard in Excel
2003


Thanks,




Avi Benita 054-4660641 wwwAvi Benita 054-4660641 www.avibenita.com

 

[Norman Jones]

Hi Avi,

Try:

Application.CutCopyMode=False

 

[ste mac]

Hi Avi, this is what I use, its one of Chips...works fine

ste

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub

 

[Chip Pearson]

Application.CutCopyMode=False

This doesn't clear all the data in the clipboard, only Excel
data. Text will remain. To fully clear the clipboard, use

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 AAA()
OpenClipboard 0&
EmptyClipboard
CloseClipboard
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Norman Jones]

Hi Chip,

Thank you for the correction and elucidation.