Opening PDF file from excel dropdown

[Kumar M B]

hi Awesome people,

I have a requirement of opening PDF files based on the dropdown selection in Excel. Is there any way i can do it using code or linking the PDFs to the cells? Please reply asap.
I have attached an excel as well as sample PDFs.

thanks in advance.
Kumar

 

[AlanSidman]

Here is a tutorial on how to convert PDF to excel.

http://blogs.adobe.com/acrobatforlifesciences/2009/03/converting_a_pdf_file_to_excel/

 

[Mike86]

Try using the Hyperlink function with your PDF files. Make a series of hyperlinks in C2:C5 to replace the text in your drop down list. For example:

URL for first file
URL for second file and so on.

This will give you the drop downs, but the URLs won't work in A2. What you have to do is add a hyperlink in a nearby cell (like the one below your drop down cell). This hyperlink references Cell A2 and will work with the selected link. It would look something like this if you put it in your example sheet in cell a3:

=hyperlink(a2,"Go To File")