asked on

Clipboard...

Is there any way to detect what text is currently on the clipboard through some code in VBA?

Cheers
Matt

ASKER CERTIFIED SOLUTION

R_Rajesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mvidas

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LoNeRaVeR9

R_Rajesh:

I wondered why the GetFromClipboard method worked in my Personal.xls and not in other Modules. It was due to the missing references. That is very helpful.

Thanks!

Jaes

generali

ASKER

I get the following error:

Dataobject:GetText Invalid FORMATETC structure

I am actually using code specific to an external application to copy the text, does this make any difference?

And I used:

If MyDataObj.GetText() = "" Then
GoTo MOD1RESUME
Else
Sheets("DataGather").Select
---------------------------
I can use "" cant I??

R_Rajesh

the clipboard content has to be in text format. try this

Dim MyDataObj As New DataObject
MyDataObj.GetFromClipboard
If MyDataObj.GetFormat(1) = True Then
MsgBox MyDataObj.GetText()
Else
MsgBox "Clipboard empty or Data in clipboard in not in text format"
End If

generali

ASKER

Cheers again Rajesh, and thankyou OM !

Matt

R_Rajesh

thanks for the grade, Matt(generali)
could i ask you what OM stands for??

generali

ASKER

No probs rajesh, yeah OM stands for other Matt !

mvidas

:) Thanks!

R_Rajesh

lol, spent almost 5mins thinking of all combinations. wasn't even close :)

mvidas

Heh, ohso much, old man, on me

Congrats on the wizard cert by the way! I'll officially congratulate you when an official congratulations thread shows up (I'd start one now but I have to run for a couple hours).

Cheers!

R_Rajesh

thanks Matt, I appreciate it.
still working hours at your end i believe :(
its bed for me... :)