VBA, Clear Clipboard

Clear Clipboard

Author	Message
Sean Hanso #1 / 3	Clear Clipboard I would like VBA to clear the clipboard (in OFF2K) after it commits a paste with formatting. Lines one and three make sense to me, but I do not know how to tell the clipdoard toolbar to clear the clipboard of all items (line two). 1) CommandBars("Clipboard").Visible = True 2) CommandBars("Clipboard"). 3) CommandBars("Clipboard").Visible = False Any advice!?!? TIA Sean Hanson
Sat, 18 Jun 2005 22:29:35 GMT

Chirag Dala #2 / 3	Clear Clipboard The following one line procedure will clear the clipboard: --- Sub ClearClipboard() CommandBars.FindControl(Id:=3634).Execute End Sub --- - Chirag http://officerone.tripod.com/ Quote: > I would like VBA to clear the clipboard (in OFF2K) after > it commits a paste with formatting. Lines one and three > make sense to me, but I do not know how to tell the > clipdoard toolbar to clear the clipboard of all items > (line two). > 1) CommandBars("Clipboard").Visible = True > 2) CommandBars("Clipboard"). > 3) CommandBars("Clipboard").Visible = False > Any advice!?!? > TIA > Sean Hanson
Sat, 18 Jun 2005 23:03:03 GMT

Sean Hanso #3 / 3	Clear Clipboard Thank you very much. It works like a charm. Quote: >-----Original Message----- >The following one line procedure will clear the clipboard: >--- >Sub ClearClipboard() > CommandBars.FindControl(Id:=3634).Execute >End Sub >--- >- Chirag > http://officerone.tripod.com/ >> I would like VBA to clear the clipboard (in OFF2K) after >> it commits a paste with formatting. Lines one and three >> make sense to me, but I do not know how to tell the >> clipdoard toolbar to clear the clipboard of all items >> (line two). >> 1) CommandBars("Clipboard").Visible = True >> 2) CommandBars("Clipboard"). >> 3) CommandBars("Clipboard").Visible = False >> Any advice!?!? >> TIA >> Sean Hanson >.
Sat, 18 Jun 2005 23:29:19 GMT

Page 1 of 1

[ 3 post ]