URGENT - make drop down box select open file automatically

[Muzza86]

need this a.s.a.p.

I have attached an example sheet with something that should be easy for you ...

to sum up - need a drop down box - that when "flange" is selected - It opens a file automatically - no clicking etc. just when that option in the drop down box is chosen.

thanks


ps. what I tried initially was something like this..

sub openfile()

if range("d3" = "flange") then
openfile thisworkbook.path "\file.pdf"
end if

end sub

but doesn't work, plus means I have to click on something.. etc