Excel clipboard 1

[wuxapian]

Hi all,

I need to get Excel to read data in from the clipboard. I have placed data on the clipboard from a VB application and I need an excel file (using vba) to copy the data from the clipboard to a variable before it is output to the cells.

Does anyone have any examples of this or point me in the right direction?

Thanks
Wuxapian...

 

[SkipVought]

Hi,

Read the help on GetFromClipboard Method
There are various methods to get data from the dataobject

First I copied some text in Word.

Sub GetDataFromClipboard()
    Dim MyData As DataObject
    
    Set MyData = New DataObject
    
    MyData.GetFromClipboard
    MsgBox MyData.GetText(1)
End Sub

Skip,
metzgsk@voughtaircraft.com

 

[wuxapian]

thanks for that, worked a treat.

Wuxapian...