opening non microsoft program from excel
 

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

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.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
is it possible to be able to read an e book in adobe reader from a macro
in
excel just to get certain figures .
--
BD3

thanks bob ill try that.
--
BD3


"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
is it possible to be able to read an e book in adobe reader from a macro
in
excel just to get certain figures .
--
BD3

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
--
BD3


"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
is it possible to be able to read an e book in adobe reader from a macro
in
excel just to get certain figures .
--
BD3

Hi Bob again
Thanks for that ive sorted it out it works fine
--
BD3


"Bob Phillips" wrote:

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.

--
HTH

Bob Phillips

"bigdaddy3" wrote in message
...
is it possible to be able to read an e book in adobe reader from a macro
in
excel just to get certain figures .
--
BD3