to open a pdf file from a macro in excel

B

bigdaddy3

With the code below i can open adobe acrobat 7 from within excel with a macro
but what i want to do is open a particular adobe pdf file from my documents
folder i
added the code in brackets , adobe opened but said file not found. Any help
appreciated

Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe ( C:\Documents
& Settings\My Name\My Documents\MyFile.pdf)",vbNormalFocus
 
L

L0ckm4

Hi,

Try it without the brackets - it seems to work with me. I have full adobe
though, but i dont see why that should make too much of a difference.

i used

Shell "C:\Program Files\Adobe\Acrobat 7.0\Acrobat\Acrobat.exe C:\Documents
and Settings\My Profile\My Documents\mypdf.pdf", vbNormalFocus

HTH

Mark
 

Ask a Question

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.

Ask a Question

Similar Threads

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
to open a pdf file from excel 2
Loosing transparency effect of Master Page graphic when Saving Publisher files as .pdf 0
Solution for Application.FileSearch Excel 2007-2010 2
Open PDF File Using Reader 8 3
Saving a Word document as PDF from en Excel macro 2
Print batch to pdf 1
Converting excel to PDF, single page converts to multiple HELP! 1

Top