Open pdf file selected from excel

I am using this code to select a folder and diplay the pdf files in that folder..

Please Login or Register  to view this content.

Of course when I select a pdf, excel opens it and it becomes gibberish.
How can the select file be opened with acrobat reader?
xl2000

Use the SHELL command.
Provide the path and name of the reader and the name of the pdf to open.

Please Login or Register  to view this content.

Originally Posted by Andy Pope

Use the SHELL command.
Provide the path and name of the reader and the name of the pdf to open.

Please Login or Register  to view this content.

Thanks Andy,
I have it as far as Acrobat opening, but it can't find the file selected :

Please Login or Register  to view this content.

What should be at the end of the shell line?

You need to more your variable outside to the quotes.

Please Login or Register  to view this content.

this assumes fn contains full path and file name. If not also include P

If you must post your question elsewhere please include a link.

Darn, Now acrobat won't open.
When I hover over the fn it shows the correct path and file name that was selected.

When the fn is inside the quotes, acrobat opens but errors and says can't find file.

When code looks like this

Please Login or Register  to view this content.

VBA error, can't find file

Are you sure your path to the reader is correct.
Mine is,

C:\Program Files\Adobe\Acrobat 7.0\Reader

You appear to have,
C:\Program Files\Adobe\Reader 8.0\Reader\

Yes it's the correct path, I just copied and pasted it into my code
Here's an additional code I added,

Please Login or Register  to view this content.

the retVal opens Acrobat nicely but does not open the file selected

You have placed the file to open outside of the shell command

Please Login or Register  to view this content.

Still get the Acrobat error
This works though

Please Login or Register  to view this content.

Thank you very much,after researching the web, it looks like Abobe8 may have some issues,
The Hyperlink code seems to open whatever file is selected in it's defaulted program, is this the case?

If version 8 if flakey then I would stick with the hyperlink approach if that works.