Time stamp template

[AJSchwayze]

Hi,

I'm trying to create a time stamp template that will open with every new work book I create in excel. I have saved the book as an xltx file and moved it into my xlstart folder after going into page set up and typing in &[date] &[time] but when I open new books, this template is not applied. Can someone help me with this? Im very perturbed because my macro workbook always opens and it is located in the xlstart file as well.

[solnajeff]

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

Please Login or Register  to view this content.

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