More macro help, please

[amyenoch]

I got such great help with my last question - can anyone help with this?

I have a file that is a log that lists construction tools by their assigned number. The following macro opens another file that is a blank detail form, pastes the tool's assigned number into cell b1, and saves that new form to the file name equal to the tool's assigned number (cell b1). For instance, on the log, there is an entry for tool number 1001; the macro opens the blank detail form, pastes the tool number 1001 in cell b1, then saves the file with the name "1001". Here's the macro, my question following:
------------------

Sub a()
'
' a Macro
' Macro recorded 5/12/2005 by David and Amy Enoch
'

'
Selection.Copy
Application.Run "'Tool Log-working doc.xls'!Open_New_Detail"
ActiveSheet.Paste
Windows("Tool Log-working doc.xls").Activate
Application.CutCopyMode = False
Windows("sample tool detail file.xls").Activate
ActiveWorkbook.SaveAs FileName:= _
"C:\Documents and Settings\Administrator\My Documents\" & Range("b1").Value & ".xls", FileFormat _
:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _
False, CreateBackup:=False
End Sub
------------------------

Now I would like to create a hyperlink in the original log that will allow the user to go directly to the new detail file (e.g., "1001"). I want the hyperlink on the same row as the tool in question, but not in the same cell as the tool number designation. It will be in column J, but the row will vary by tool number. How can I expand the above macro to now create a hyperlink to that new tool detail file? It would need to be a relative cell reference.

I hope this makes sense!! I'm not a programmer! Thanks for your help.

[amyenoch]

Anyone have any ideas on this? Appreciate any help.