Open a PDF document

[Naomi]

Hi,

How do I open a PDF file (in acrobat) from excel in VB?

Thx.

 

[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.