opening non microsoft program from excel

B

bigdaddy3

is it possible to be able to read an e book in adobe reader from a macro in
excel just to get certain figures .
 
B

Bob Phillips

Something like

Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe C:\My
Documents\myFile.pdf", vbNormalFocus

You will need to ensure the correct path for the reader exe.
 
B

bigdaddy3

thanks bob ill try that.
--
BD3


Bob Phillips said:
Something like

Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe C:\My
Documents\myFile.pdf", vbNormalFocus

You will need to ensure the correct path for the reader exe.
 
B

bigdaddy3

Hi Bob
i tried the following from a macro and it kept throwing up syntax
error any ideas
Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe C:\My
Documents\Correct New\Staff Folders\tablsa.pdf", vbNormalFocus

tablesa is the pdf document i need to show
 
Top