Macro/module to paste into an OLE object?

[omahadivision]

Hello!

I am new here but I've been reading a lot of old articles as I build my database.



I have a fairly simple question that I can't seem to find an answer to. I have a form with an OLE object, and I want to find a way to make a command button that automatically pastes whatever is on the clipboard in it instead of right-clicking and putting in paste. It seems quite simple, but I haven't found anything on it yet.

Thanks!

-Dave

[June7]

Maybe this has what you need http://www.cpearson.com/excel/clipboard.aspx

[omahadivision]

Maybe this has what you need http://www.cpearson.com/excel/clipboard.aspx

Thanks! That has almost everything I need, except how would I specify it to paste in the OLE box from the Access side? Thanks again!

[June7]

Not sure. Never worked with the OLE controls. You want to copy/paste an image? Why?

I think the sample code is assuming clipboard data is a string. Don't know if could modify function to handle image instead of text.

[omahadivision]

Not sure. Never worked with the OLE controls. You want to copy/paste an image? Why?

I think the sample code is assuming clipboard data is a string. Don't know if could modify function to handle image instead of text.

Basically, I have a macro that would open an excel file, copy a image, and then close it, and I'd like the graph to be pasted into my ole box on my form. I'll fiddle around more with the pasting issue.

[omahadivision]

I'm thinking there might be an easier way, using an OnClick sub for the box

[June7]

Regardless of the event, issue is the same. Can the code be modified to handle an image?

[omahadivision]

Basically, I have a macro that would open an excel file, copy a image, and then close it, and I'd like the graph to be pasted into my ole box on my form. I'll fiddle around more with the pasting issue.

All right, I am almost there! I put in DoCmd.RunCommand acCmdPaste for the double-click on the OLE object! Now I just have to transfer that to a button and I'm done! This part seems easy, but I'll admit that I'm stuck. Is it easier to program a button to simulate the double-click or just link to it directly?

[June7]

The graph pasted?

The button Click event can call the OLE control event procedure.

Assuming everything is on the same form.

Sub buttonname_Click()
Call OLEobjectName_DblClick()
End Sub

If that doesn't work, maybe have to just put a label above the OLE control:
"Double click the box below to paste graph."

[omahadivision]

It all works now! Evidently single click allows more things than double click. Thank you very, very much! How do I mark this as solved?

[June7]

I marked solved. Option under Thread Tools at top of the thread.