Launching a PDF file from Access97

[Bob]

I have users that have various versions of Adobe Acrobat
(4.0, 5.0, 6.0) and since they are not installed in the
same directory I need a way to find the installed version
to display a PDF. You would think that just calling the
Access Shell() program with the "filename.PDF" would
launch it but no dice. I have set up an IF structure to
set the directory & name of all the Adobe Reader and Full
Acrobat EXE's I know of but suppose the user has installed
in a different directory.

Anyone know how to launch a PDF besides Shell()? Mayby an
API to get the location of Adobe Reader/Acrobat from the
Registry?

TIA
Bob

 

[Douglas J. Steele]

If you use the ShellExecute API, you don't need to know where the executable
is.

Check out http://www.mvps.org/access/api/api0018.htm at "The Access Web" for
sample code.

 

[Albert D. Kallal]

You can use:

application.FollowHyperlink "c:\my documents\test.pdf"

The above will launch any application using the correct extension. So, you
can use this for word, excel, or a PDF doc...