Clear Clipboard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vbaNOOB - 23 Mar 2007 09:58 GMT

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

Reply to this Message

Helmut Weber - 23 Mar 2007 13:21 GMT

Hi,

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

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

Signature

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

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

Reply to this Message

Tony Jollans - 23 Mar 2007 14:48 GMT

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

Signature

Enjoy,
Tony

> Hi
>
[quoted text clipped - 12 lines]
>
> but it seems not work

Reply to this Message

vbaNOOB - 02 Apr 2007 03:50 GMT

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

> You cannot (post 2000) access the Office clipboard from VBA. The code you
> post is for the Windows clipboard.
[quoted text clipped - 15 lines]
> >
> > but it seems not work

Reply to this Message