harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
I have an embedded object (pdf) in my sheet. I have a Command Button to open up that object. Here is the code I have:
Private Sub CommandButton4_Click()
With ActiveSheet
Set o = .OLEObjects("Object 15")
o.Verb xlVerbOpen
End With
End Sub
However, after I click the button, the pdf does open up but i get a run time error 1004: Cannot start the source application for this object. When I click Debug it highlights the line:
o.Verb xlVerbOpen
Any help on how to fix this? Much thanks!
Private Sub CommandButton4_Click()
With ActiveSheet
Set o = .OLEObjects("Object 15")
o.Verb xlVerbOpen
End With
End Sub
However, after I click the button, the pdf does open up but i get a run time error 1004: Cannot start the source application for this object. When I click Debug it highlights the line:
o.Verb xlVerbOpen
Any help on how to fix this? Much thanks!