Opening Files From Spreadsheet using VBA

[ando1976]

Hi there,

I have a piece of code that I use to open up files (in this case, a pdf file) on my hard drive, however it opens it up and displays the file as an image, rather than as a pdf file via the Adobe program - see code below:

Please Login or Register  to view this content.

I would like help on two matters here:
1. How can I open the file via Adobe (or similar) rather than as an image?
2. How do I get the program to search using a different directory (rather than C:\ drive), as I plan on sending out the completed Excel file to customers on a CD or thumb drive. Not know what my customer's directory name will be makes this piece of code redundant apart from on my machine where I know I keep the pdf files.

Hoping that someone can assist me with this enquiry.

Thanks

Mark

[arlu1201]

Mark,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

[JosephP]

Please Login or Register  to view this content.

oughta work for any registered file type