Are you sure that the pc has Reader installed?

Another option (also worked for me):

ActiveWorkbook.FollowHyperlink "c:\myfolder\myfile.pdf"

(Did you include the complete path when you tested the Start suggestion?)



James wrote:

I tried before I submit the question. Failed.

But thanks anyway. :

----- Dave Peterson wrote: -----

Ahhh.

maybe something like:

Shell "start myfile.pdf"

James wrote:
I want to open the PDF in Acrobat Reader, not importing it into Excel. But use Excel VBA.
----- Dave Peterson wrote: -----
You could search google for pdf translators (to excel or to text files). Most
are commercial ($).
You might get lucky and be able to copy each column and paste into excel (column
by column)--from Adobe Reader.
James wrote:
I mean, I got a PDF file. I want to use Excel VBA to open that PDF in Acrobat Reader. Just like when you double-click a PDF using the mouse.
--
Dave Peterson



--

Dave Peterson



--

Dave Peterson