live hyperlink query

[rvd48]

hi,
i have a excel sheet where i keep a log of some information in each row.
Per row, there is a unique reference, e.g. J:\a) Non Standard\A123.xls. this represents an excel document in another folder.

Now, i would like this reference column to be live, so that when i click on the reference of AA123, it goes straight to that file.

is there a simple way to do this besides manually adding the hyperlink?
i continually add new rows of information into the log, so its important to me that i can get this to work.

thankyou

 

[unmarkedhelicopter]

I assume that "a) Non Standard" is a valid folder and that each cell you wish to convert has a valid system file object in it then :-

    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=ActiveCell.Value, TextToDisplay:=ActiveCell.Value

Can be used as a single cell conversion
You did not say if you have a range to do or just spot ones here and there.
If you need a range converting it would be something like :-

dim rCell as range
for each rCell in Range("H2:H972")
 ActiveSheet.Hyperlinks.Add Anchor:=rCell, Address:=rCell.Value, TextToDisplay:=rCell.Value
next rCell

 

[rvd48]

sorry helicopter, im some what of a noob with vb code

yes, the a) Non Standard Sign Offs is a valid folder with all the individual files such as AA123.


where do i put this code? in the vb code bit of the 'workbook'?

cheers, rvd