VBA, Clearing the Clipboard

Yehuda Rosenblu
#1 / 4

Clearing the Clipboard

How do I clear the office 2000 clipboard in VB? (clipboard.clear cannot get
all 12 clipboards

Fri, 11 Apr 2003 03:00:00 GMT

Jonathan Wes
#2 / 4

Clearing the Clipboard

Hi Yehuda,

VBA has no access to the additional clipboards.

--
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
Word FAQs at http://www.multilinker.com/wordfaq
Please post any follow-up in the newsgroup. I do not reply to Word questions
by email

Quote:

> How do I clear the office 2000 clipboard in VB? (clipboard.clear cannot
get
> all 12 clipboards

Fri, 11 Apr 2003 03:00:00 GMT

Shyam Pilla
#3 / 4

Clearing the Clipboard

Hi Yehuda,
No direct method to clear the multiple clipboards in Office 2000 but you
could do the following to achieve the same effect. The error handling is
provided only as contingency while running under 97 where the 'clipboard'
does not exist.

' ----- Beginning Of Code -----
Sub ClearTheClipBoard()
Dim oClipClear As CommandBarButton
On Error Resume Next
Set oClipClear = Application.CommandBars("clipboard") _
.FindControl(Id:=3634)
If Not oClipClear Is Nothing Then
If oClipClear.Enabled Then oClipClear.Execute
End If
On Error GoTo 0
End Sub
' ----- End Of Code -----

--
Regards
Shyam Pillai

http://officetips.homepage.com

Please reply in newsgroup - No email replies .

...

Quote:

> How do I clear the office 2000 clipboard in VB? (clipboard.clear cannot
get
> all 12 clipboards

Sun, 13 Apr 2003 03:00:00 GMT

Yehuda Rosenblu
#4 / 4

Clearing the Clipboard

Thank you very much

Quote:

> Hi Yehuda,
> No direct method to clear the multiple clipboards in Office 2000 but you
> could do the following to achieve the same effect. The error handling is
> provided only as contingency while running under 97 where the 'clipboard'
> does not exist.

> ' ----- Beginning Of Code -----
> Sub ClearTheClipBoard()
> Dim oClipClear As CommandBarButton
> On Error Resume Next
> Set oClipClear = Application.CommandBars("clipboard") _
> .FindControl(Id:=3634)
> If Not oClipClear Is Nothing Then
> If oClipClear.Enabled Then oClipClear.Execute
> End If
> On Error GoTo 0
> End Sub
> ' ----- End Of Code -----

> --
> Regards
> Shyam Pillai

> http://officetips.homepage.com

> Please reply in newsgroup - No email replies .

> ...

> > How do I clear the office 2000 clipboard in VB? (clipboard.clear cannot
> get
> > all 12 clipboards

Tue, 15 Apr 2003 03:39:43 GMT