Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to open a PDF from Excel VBA. I do not want to specify the
full path to "AcroRd32.exe" as it may be installed in different locations on different PC's. I found the following code from Tom Ogilvy but when I run it I get a file not found error. I know the file exists. I can browse to it and double click it to open it. I want the "Test.pdf" file to open with what ever program is associated with a ..PDF in windows. I do not want to specify the program to use to open the file. Sub OpenPDF() Shell "Start.exe ""C:\temp\Test.pdf""" End Sub -- Regards, Tom Ogilvy I am running windows XP Thanks Scott Riddle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
Opening files in Excel 2003 saved in Excel 2000 without data loss... | Excel Discussion (Misc queries) | |||
Trouble opening large size Excel file 155Mb in Excel 2007 | Excel Discussion (Misc queries) | |||
REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming |