Thread: .PutInClipboard
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
USH USH is offline
external usenet poster
 
Posts: 7
Default .PutInClipboard

hELLo EVERYBODY !!
I found this sub on some useful site..
she makes all it's expected from her..
( copy a value to clipboard that will be pasted to an external program
with a mouse macro..)
now everything is working well..
but i don't understand the suggestion in the commented block...
nor if and what i have to do about. tx ! paolo

Sub CopytoClipboard()
' Requires a reference to Microsoft Forms Object Library
' An easy way to do this is to add and then delete a form;
' the reference will persist
With New DataObject
.SetText ActiveCell.Value
.PutInClipboard
End With
End Sub