Time stamp template

Hi

So far as I am aware a template file will not open automatically only an xls file.

One way to get around your problem would be to create a simple file, e.g Link with a Workbook Open macro something like this

Private Sub Workbook_Open()

    Workbooks.Add Template:= _
        "C:\Users\YourName\AppData\Roaming\Microsoft\Templates\Timestamp.xlt"
    Windows("Link").Close
End Sub

This will require macros to be enabled, either by default with low security (not advisable) or on clicking to enable with medium security. The address is the format for Vista and would be different in Windows XP. You can simply record the macro to get the code you need.

Regards

Jeff