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

Hi Avi,

Try:

Application.CutCopyMode=False

---
Regards,
Norman



"Avi" wrote in message
...
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

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

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" wrote in message
...
Hi Avi,

Try:

Application.CutCopyMode=False

---
Regards,
Norman



"Avi" wrote in message
...
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

Hi Chip,

Thank you for the correction and elucidation.

---
Regards,
Norman



"Chip Pearson" wrote in message
...
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" wrote in message
...
Hi Avi,

Try:

Application.CutCopyMode=False

---
Regards,
Norman



"Avi" wrote in message
...
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