Send from clipboard to excel sheet

[gombi]

Hi!

I don't think thats possible, but if yes please teach me!

I want to send the content of the clipboard to an excel macro when the excel sheet
is not the active window. So I'm working in a different application and when I press
a key combination, the content of my clipboard will be send to excel.

Is that somehow possible?

Thanks a lot!

[romperstomper]

Not with Excel. You'd need your active program to be in charge of that.

[gombi]

Ok!

So I will have to tab back to the excel sheet.

And can I paste there the clipboard content with a click on a button?

I saw something about 'sendkey'. Is that the right direction?

Thanks!

[MarvinP]

Why not use Ctrl-V which is the window Paste shortcut?

[gombi]

Because with that I have to select the cell and do a key combination.
Thats do long! The user will do that around 1000 times a month.

So one click vs selecting the cell and Ctrl-v!

[Leith Ross]

Hello Gombi,

Which application are you using? If it supports COM then the copying and pasting to the clipboard can be done with the Windows API.

[snb]

Which application ?

If this application uses VBA you can paste with

Please Login or Register  to view this content.

[gombi]

It's a factory intern software. I don't know much about the application. But anyway there is no change to change anything and I don't have admin privileges on the system. So sending somthing to excel will not work for me.

But I would like to try to paste the content with a click on a button in excel.

How can I do that?


Thanks for the answers!

[Leith Ross]

Hello Gombi,

We are shooting in the dark here because we don't know anything about your application software, not even the name. Which begs the question: How can we provide a solution to transfer information between the programs when one is a complete mystery?

[gombi]

Thats not a public application! I already forgot about the option to send it to excel
because that will not work in my case.

I just want a macro that pasts my clipboard content in a cell when I click on a button in
the excel sheet. Can I do that with 'sentkey'?

Thanx!

[romperstomper]

Where is it supposed to paste to? There are plenty of paste buttons already on the toolbar so I don't see why code is needed at all?

[romperstomper]

For the record, you can actually do this from Excel using the Windows API and keyboard hooks, but it's not something I would recommend if you don't know what you are doing - if Excel were to crash, for example, with the hook in place, the results might be unpredictable.
With that caveat in mind, here's an example (it hooks the PrintScreen key in all open apps and pastes to the activecell in Excel):

Normal module:

Please Login or Register  to view this content.

ThisWorkbook module:

Please Login or Register  to view this content.

[gombi]

Thank you.

Let's say I wanna paste the clipboard content witch is a name like "mister smith" to A1
with one click on a button within the excel sheet. With one click, A1 should be selected
and the name should be pasted into it.
Like simulating ctrl-v.

[gombi]

Please Login or Register  to view this content.

Ok! I do it like that!