opening/extracting ole object file in excel via excel VBA

[naris]

Hi,

I want opening or extracting ole object file in excel via excel VBA , would you help me give the macro script to run it ?

Thanks,
Naris

[Kenneth Hobs]

To open an embedded ole object in Excel, doubleclick it. Otherwise, you will need to explain what the OLE object is and what you expect to do with the contents in Excel. An attached xls usually helps us help you better.

[naris]

Dear Kenneth Hobs,

I want extracted or opened the ole object contained pdf file in my excel file without double clicking the ole object, but via excel macro (please see the file enclosed ), I hope you can help me for this.
Thanks you for response.

Regards,
Naris

[Benzadeus]

Just set the macro to the OLE object instead the shape.

[Kenneth Hobs]

Does your recorded macro not do what you wanted? It can be simplified by:
[vba]Sub Macro1()
ActiveSheet.Shapes("Object 3").Select
Selection.Verb Verb:=xlPrimary
End Sub
[/vba]

Or the one liner:
[VBA]ActiveSheet.OLEObjects("Object 3").Verb xlPrimary[/VBA]

[naris]

thanks

naris