How to load a PDF using Excel VBA? Can anyone give sample code

Many thanks in advance!

Hi
what do you mean with 'load PDF'. Note: Its not so easy to convert a
PDF document back to an Excel file format (has nothing to do with VBA)

--
Regards
Frank Kabel
Frankfurt, Germany


James wrote:
How to load a PDF using Excel VBA? Can anyone give sample code?

Many thanks in advance!

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

Hi James
o.k. that's simple :-)
have a look at the VBA Shell method. e.g.
Shell "mypdffile.pdf"

--
Regards
Frank Kabel
Frankfurt, Germany


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.

"Frank Kabel" wrote:
<<Shell "mypdffile.pdf"

Does this really work on your machine? I had trouble with this (Win ME and
Excel 2000 SP-3).
(See my post about an hour before yours.)
(Need to resynchronize your newsreader every 15 minutes or so?)
--
Regards,
Bill