Reading Clipboard in VBA Word

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.

Code:

---

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

---

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

Code:

---


      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

---

Hello geoff_xrx,

Thanks for your helpfull information.

Michelle.