Opening embedded object in VBA

ppataki

Registered User.
Local time
Today, 01:59
Joined
Sep 5, 2008
Messages
267
Dear All,

I inserted a Word file into a form as an unbound object
If I doubleclick on it in Design view the file opens, no problem

My problem is that I have a button, and I would like to use the button to open the Word file embedded

Could you please advise?
Many thanks in advance
 
I got the solution:
controlname.Verb = acOLEVerbShow
controlname.Action = acOLEActivate
This code opens the specified OLE object!
 

Users who are viewing this thread

Back
Top Bottom