VBA to open .pdf file embedded in XL W/S

D

Dennis

Using 2003

Below is the macro I recorded opening an Adobe.pdf file which is embedded in the same worksheet.

Sub Macro1()
ActiveSheet.Shapes("Object 32").Select
Selection.Verb Verb:=xlPrimary
End Sub

When I open the file (also when the macro was recorded) Acrobat came up - all seemed OK.

But when I attempted to run the macro, I get a VBA error "cannot open application."

What am I missing?

Thanks for any thoughts

Dennis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top