Clear Clipboard

[vbaNOOB]

Hi

I have a vba that will do copy and paste thing from the active doc to a new
doc.
After running the program, I got some items in the clipboard
how can I clear/delete these item from the clipboard.

I have try sth like this (from the web)
Dim MyData As DataObject

Set MyData = New DataObject
MyData.SetText ""
MyData.PutInClipboard

but it seems not work

 

[Helmut Weber]

Hi,

what doesn't work?
Do you get an error message?


http://word.mvps.org/faqs/macrosvba/ManipulateClipboard.htm

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Tony Jollans]

You cannot (post 2000) access the Office clipboard from VBA. The code you
post is for the Windows clipboard.

 

[vbaNOOB]

That mean, I cant clear the office clipboard using VBA??