opening non microsoft program from excel

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

[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.

--
HTH

Bob Phillips

"bigdaddy3" <bigdaddy3@discussions.microsoft.com> wrote in message
news:EB463188-1B99-494E-82B1-265E9049382B@microsoft.com...
> 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

[bigdaddy3]

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" <bigdaddy3@discussions.microsoft.com> wrote in message
> news:EB463188-1B99-494E-82B1-265E9049382B@microsoft.com...
> > 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
>
>
>

[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
--
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" <bigdaddy3@discussions.microsoft.com> wrote in message
> news:EB463188-1B99-494E-82B1-265E9049382B@microsoft.com...
> > 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
>
>
>

[bigdaddy3]

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" <bigdaddy3@discussions.microsoft.com> wrote in message
> news:EB463188-1B99-494E-82B1-265E9049382B@microsoft.com...
> > 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
>
>
>