Help - Bariloche

Posted by Stephen Allenberg on January 15, 2002 6:03 AM

I thank you for your assitance but would like to askyou please to explain a bit furhter as I have no Excel programming knowledge - I have successfully done what you say but once I have pasted it in I do not know how to save this and incorporate it into every worksheet that I use ???

Posted by Barrie Davidson on January 15, 2002 6:17 AM

Bariloche, sorry to step in on you

Stephen, you'll need to save your workbook as an Excel template. Here is the instructions from Excel's help.

1 Create a workbook that contains the sheets, default text (such as page headers and column and row labels), formulas, macros, styles, and other formatting you want in new workbooks that you base on the template.

2 On the File menu, click Save As.

3 In the Save as type box, click Template (*.xlt).

4 In the Save in box, select the folder where you want to store the template.

To create the default workbook template, select either the XLStart folder in the Microsoft Excel folder or the alternate startup folder.

To create a custom workbook template, select the Templates folder in your Office folder or Microsoft Excel folder.

5 In the File name box, type "book" to create a default workbook template.

To create a custom template, type any valid file name.

Hope this helps you out,
BarrieBarrie Davidson

Posted by Stephen Allenberg on January 15, 2002 11:25 AM

Barrie Bariloche

Barrie

Thank you for the info that you provided. please clarify - Is this all done from XL. I have got the Xlstart folder - it is from here that I am a bit confused creating the workbook template

Regards
Stephen

____________________________________________

Posted by Barrie Davidson on January 15, 2002 11:35 AM

Re: Barrie Bariloche

Stephen, it is all done in Excel. In "Help", do a search on "Create a workbook template for new workbooks" and follow the instructions (I copied them in my first response).

Regards,
Barrie

Barrie Davidson

Posted by Bariloche on January 15, 2002 5:42 PM

Barrie, not a problem

Glad you did step in.

I'm at the day job from about 6:00 til 16:00 (board time) so I appreciate you helping Stephen out.

thanks

Posted by Stephen W Allenberg on January 15, 2002 5:45 PM

Barrie Bariloche

Barrie

I have followed all the steps that you have given me and have been
able to create a template - now I need to what (and how) to put
in to the Y1&Z1 cells - because when I put in today() it gives
me todays date each time. When I open this template do I rename
the file as whatever I wish to call it and save as ???.xlt

Regards
Stephen