Help with Shell to Acrobat Reader

[Jimbo]

I wish to shell to adobe acrobat from within excel and because the workbook
may be on different standalone workstations I would like to use a variable
to store the program and location associated with .pdf files

I'm stumped ... please help

Regards and TIA

 

[Guest]

Try something like:


Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.pdf", 1)
End Sub


Note that by shelling to cmd.exe you don't need to open the application
directly.