Linking Word Templates to Excel Spreadsheet

[lisa1]

I have created a large number of work instructions using Word templates and I would like to make it easy for our engineers to figure out which template to use for each product. I have created an Excel spreadsheet with drop down boxes that allows them to fill out certain information about the part. Once all the information is filled in, it gives the title of the template they need to use. To make this even easier, I would really like to link the templates to the spreadsheet so when it decides the title of the template needed, it gives a link to the it so all they have to do is click on the link and fill out the sheet. Is this possible? Let me know if this doesn't make sense and I will try to explain it a little better.
Thanks!
Lisa

 

[pbornemeier]

If the title of the template is in a cell, you could use VBA that triggers when the title is displayed to add a hyperlink to that cell.

Turn on the macro recorder and manually add a hyperlink and the resulting code can be edited for reuse.

If the title of the template is not the same as the filename of the template then you will have to make a lookup table.

 

[lisa1]

Phil,
The title of the template is the same as the filename of the template and it will be displayed in a cell. Could you please explain how to use VBA to add a hyperlink to the template? I'm fairly new to this stuff.
Thanks a bunch!

 

[pbornemeier]

This code deletes adds a hyperlink and screen tip to the specified cell on worksheet 1:

With Worksheets(1)
    .Hyperlinks.Add Anchor:=.Range("a5"), _
        Address:="http://example.microsoft.com", _
        ScreenTip:="Microsoft Web Site", _
        TextToDisplay:="Microsoft"
End With

And a belated 'Welcome to the Board!'