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

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.
--
Gary's Student


"Jimbo" wrote:

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