View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
gregschottland gregschottland is offline
external usenet poster
 
Posts: 1
Default clearing the office clipboard in vba

So I've got this compiling and running in Word under Office 2003, but it
doesn't clear the clipboard for me. I copy several items, show the clipboard,
see them. Then run this macro, and they remain there. Am I missing something?

Thanks!

"ste mac" wrote:

Hi, try this, its one of Chips.. l use it all the time..

Public Sub ClearClipboard()
Dim MyDataObj As New DataObject
MyDataObj.SetText ""
MyDataObj.PutInClipboard
End Sub

seeya ste