Opening a PDF document from Visual basic

[Klaus]

How do I open a pdf document from visual Basic in excel

 

[Tom Ogilvy]

Use the Shell command

Shell "C:\files\myfile.pdf"

assumes pdf is associated with a reader application that can open PDF files.

 

[klaus.goth]

It doesn't seem to work, do you have any alternatives

 

[Michael D. Ober]

PDF Documents are Adobe Acrobat files, not Excel. You can download a free
Acrobat Reader from http://www.adobe.com/products/acrobat/readermain.html.

Mike.

 

[Tom Ogilvy]

Sub Tester2a()
Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe" & _
" c:\toc1\amcr37-4.pdf", 1
End Sub

or if you have .pdf associated with acrobat reader:

Private Sub Tester2b()
Shell "Start.exe ""D:\My Documents\sm569_Jan2001\tute6.pdf"""
End Sub

are possibilities.