Excel VBA: How to get text fro0m clipboard?

[yurich]

Hi all,

In my Excell app I need to get text from clipboard, parse it and fill table...
VBA does not support Clipboard object like in VB...
I tried to use API functions, but every time it fails on CopyMemory function

Any ideas??? Short example will be very useful!

Thanks,

[BrianB]

I wonder if your method is the best one. The simplest way of getting data from the clipboard is to Paste it into a worksheet and process there. You can always delete the sheet afterwards.

If you have a text file containing data, delimited or not, use Application.WorkBooks.OpenText which will open the file and do all the work for you (best to record a macro using Excel menu File/Open).

Visual Basic for Applications does, however, have a DataObject with methods Clear, GetFormat, GetFromClipBoard, GetText, PutInClipBoard, SetText, StartDrag.

'- partial code
Dim MyDataObject As DataObject
Set MyDataObject = New DataObject
MyDataObject.GetFromClipBoard

[abhijit]

Brian,
I looked at this code, but doesn't seem to work without a form. I am trying to prevent pasting multiple columns in my excel sheet and am totally lost at the moment.

Could you give it a shot?

Regards,
Abhijit

[VBAhack]

According to "VBA Developer's Handbook", you can use clipboard API's with VBA.

VBAhack

[abhijit]

I do not have a copy of the developer's handbook.

I feel that this is something that should be solvable by using excel object.

[VBAhack]

Try a Google search, such as:

http://www.google.com/search?hl=en&q=VBA+and+clipboard

VBAhack