View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
ste mac ste mac is offline
external usenet poster
 
Posts: 117
Default clearing the office clipboard in vba

Hi, sorry l don't know (l have 2k) perhaps you could give Chip a shout
or visit his website...anyone else?

When I try and run this code I receive a User-defined type not defined ERROR
how do I set MyDataObj in Excel2003



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