G
Guest
How to load a PDF using Excel VBA? Can anyone give sample code
Many thanks in advance!
Many thanks in advance!
PDF in Acrobat Reader. Just like when you double-click a PDF using theJames said:I tried before I submit the question. Failed.
But thanks anyway. :>
----- Dave Peterson wrote: -----
Ahhh.
maybe something like:
Shell "start myfile.pdf"
Bill said:I could not get this to work until I included the full path and name of the
Adobe Acrobat reader in the command along with the desired file name.
Apparently, Shell passes the whole string directly to the command engine
without looking up the association in the registry. This could be a problem
if you are going to try to run this on a variety of machines, since the
Adobe Reader may be in different subdirectories on every machine.
Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe C:\My
Documents\Test Page.pdf", _
vbNormalFocus
(You can replace the vbNormalFocus with vbMaximizedFocus or whatever value
you want for the window style.)
--
Regards,
Bill
PDF in Acrobat Reader. Just like when you double-click a PDF using theJames said:I tried before I submit the question. Failed.
But thanks anyway. :>
----- Dave Peterson wrote: -----
Ahhh.
maybe something like:
Shell "start myfile.pdf"
mouse.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.