Error using DataObject to get clipboard data
I'm using VBA to try to get the data on the clipboard in Excel. I've found
suggestion that are variations on the following:
Dim MyData As DataObject
Set MyData = New DataObject
Dim sClipText As String
On Error GoTo NotText
MyData.GetFromClipboard
sClipText = MyData.GetText(1)
When this sub gets called in my Excel macro, I get "User Defined Type not
defined" on the first line.
Also, once this is resolved, is there a way to determine if the data on the
clipboard can be pasted into Excel (sometimes you do something in Excel that
seems to clear out the clipboard).
Any suggestions?
Thanks.
|