Hyperlink to open pdf files

Hi everyone!

Im hoping someone out there will be able to help me with a little problem I wish to solve please?

I have a works sheet that has loads of part numbers listed in column B, Im hoping somehow that any part numbers added into this column inc existing ones will be able to be clicked and open up a corresponding pdf file ( all saved under the actual part number) and open it. Like the email links that I beleive can be created. Is this possible or am I going down the wrong route?
Is 'Hyperlink' The right word even???

Many Thanks for Looking

Regards

Denzil

Hi Dave

Thanks for your quick reply!!

Sorry for asking but breaking down that line of code what does it mean?

Im Trying to learn a little, Bit of a novice!!

And can I add that to every cell in column B so all part numbers added to it
get the link aswell?

Many Thanks

Denzil

Denzil,

The =HYPERLINK() funtion creates a hyperlink with the following arguments:

(hyperlink_address,Friendly_name)

If you don't want to enter a friendly name, simply omit it.

In the reply to your original post, I used "C:\"&A1&".pdf"

The & concatenates text, so, using the above example if cell A1 contains HX85, clicking on the hyperlink will open the file C:\HX85.pdf

I hope that's clear!

Dave

Why not using the doubleclick event to open up the files in column A ? No need for extra column for hyperlink address.

Charlize

Thanks everybody for all your help!!!!!!!!!! that works great

Could you explain more about this dooble click event please?

Many Thanks in advance

Denzil