i have three columns that make up my pdf file names i.e.

example: columnA=2010, columnB=03, columnC=33 (my file name is 20100333.pdf).

i want to have a column that opens corresponding pdf files. moreover i would
like the function to look up for the files in the same drive that my excel
files relies on.

i have all these in usb and i change many computers so each computer may
give a different drive letter name to my usb.

can i achieve something like that?

p.s. i want to open the pdf file directly, not through the internet explorer.