Reading Clipboard in VBA Word

[michelle]

Dear VB users,

Is there someone who can give me code to send the information from the clipboard to a variable.

Dim QQ as String
Selection.Copy
QQ = Selection.Paste 'does not work!!!!!!!!!!!

How can I get the clipboard information to variable QQ

Nice regards,

Michelle.

[Static]

      Dim MyData As DataObject
      Set MyData = New DataObject
      Dim sClipText As String
      MyData.GetFromClipboard
      sClipText = MyData.GetText(1)
      MsgBox sClipText
VBBrowser v2.2.4

[Static]

Actually - CHange it to catch errors (unless you are sure you will always have text in it)

      Dim MyData As DataObject
      Set MyData = New DataObject
      Dim sClipText As String
      On Error GoTo NotText
      MyData.GetFromClipboard
      sClipText = MyData.GetText(1)
      MsgBox sClipText
   NotText:
      If Err <> 0 Then
         MsgBox "Data on clipboard is not text."
      End If
   
VBBrowser v2.2.4

[michelle]

Hello geoff_xrx,

Thanks for your helpfull information.

Michelle.