View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dennis Dennis is offline
external usenet poster
 
Posts: 4
Default VBA to open .pdf file embedded in XL W/S

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