ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA to open .pdf file embedded in XL W/S (https://www.excelbanter.com/excel-discussion-misc-queries/100691-vba-open-pdf-file-embedded-xl-w-s.html)

Dennis

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


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com