Hi All,
I have just tested a hyperlink to an Excel template and instead of opening
the file as a normal spreadsheet it opens as a template (xlt). The idea
behind the hyperlink was so that if you hit the hyperlink you will get a
fresh copy of the spreadsheet, not the template itself. Has anyone
experienced this problem and knows of a fix. Running XP Professional and
office 2003.

Thanks
Murray

I think that's the way hyperlinks work. The open the file--whatever the
extension.

One option is to just save the workbook as a normal .xls file and mark that file
ReadOnly (using windows explorer). Then when your hyperlink opens the workbook,
the user can't save it as that name and has to save it as a new file.

Another option would be to use a macro (maybe button right near the cell) and
have it create a new workbook based on that template.

That macro could look something like:

Option Explicit
Sub testme()

Dim myCell As Range
Dim testStr As String
Dim newWkbk As Workbook

Set myCell = ActiveSheet.Range("a3")

testStr = ""
On Error Resume Next
testStr = Dir(myCell.Value)
On Error GoTo 0

If testStr = "" Then
MsgBox "Template not available"
Exit Sub
End If

Set newWkbk = Workbooks.Add(template:=myCell.Value)

End Sub



Murray wrote:

Hi All,
I have just tested a hyperlink to an Excel template and instead of opening
the file as a normal spreadsheet it opens as a template (xlt). The idea
behind the hyperlink was so that if you hit the hyperlink you will get a
fresh copy of the spreadsheet, not the template itself. Has anyone
experienced this problem and knows of a fix. Running XP Professional and
office 2003.

Thanks
Murray

--

Dave Peterson