Open embedded object pdf file using VBA

[panama2134]

Hello and Thank you in advance,

I have an excel sheet with several PDF Forms embedded as objects, when the sheet is protected I cant click on it, therefore I'm looking for a VBA code that will allow me to click on the object AND THE pdf WILL OPEN.

This is what I have so far, and it works ok but after the file is open I get a (400 error message in excel)

Sub test2()
With ActiveSheet
Set o = .OLEObjects("Object 2")
o.Verb xlVerbOpen
End With
End Sub

I looked and looked and don't seem to be able to find a Code that could help me get this done.

Thank you Again

 

[Micron]

Unless it's a trusted locations issue, or that the correct app (or version) isn't registered for the object, I don't know.

Isn't it "affidavit"?

 

[panama2134]

no trusted location they are just blank form embedded into a spreadsheet for fast access

 

[harveya915]

I used the same code but for a command button. it does open my embedded ojbect, a PDF in this case, but i do get an error and it highlights to debug the following line:

o.Verb xlVerbOpen

This is my full code:

Private Sub CommandButton4_Click()
With ActiveSheet
Set o= .OLEObjects("object 15")
o.Verb xlVerbOpen
End With
End Sub

The error that I am getting is: Run-time error '1004': Cannot start the source application for this object.

Any help with this would be appreciated