Open an OLE object with menu commands in VBA

[RDS2]

Help please!

I have a form which displays an OLE object field. In this case the object is an Excel worksheet. If I select the control which displays the object I can click the command bar as follows:

Edit - Worksheet - Open

This will open the object in Excel, which is want I want.

My question is, can that command sequence be executed in VBA attached to a command button.

I've looked at the acCmd's but they don't include the ones I'm looking for.

 

[randy700]

Try FollowHyperlink

Randy

 

[RDS2]

I don't think there is a hyperlink with repspect to the control. I don't believe that there is evan an external address for the Worksheet. Isn't stored with the DB and only accessible through that?