Templates help

[philweb]

Hi
I have been searching around on Google for help with templates but to no avail. So I hope you guys can help?

I have a workbook that I use for entering employees hours for the month, it also keeps track of holidays and sick leave, bank holidays etc.

But what I want to do is to turn the workbook into a template, so say if I employeed another employee, I could just create a whole new workbook from that template.

That all seems easy enough. But supposing I create 20 new workbooks from this template, and then I realise I have made a mistake on the template and therefore all of the 20 workbooks are wrong, is there a way of updating the template so all of the workbooks are updated too?


Thanks

Phil

[Richard Buttrey]

Hi Phil,

Not that I know of directly Probably the best thing you can do is create a macro that will automatically correct your 20 workbooks.
Typically you would create a list of the workbook names, and then get the macro to loop down the list selectively opening each one, make the changes, save and close the workbook and then move on to the next one.

Regards

[philweb]

That sounds complicated. I guess the easier option is to check to see that there are no mistakes in the template before I create new workbooks from it!

thanks

Phil

[Richard Buttrey]

Hi Phil,,

One can't argue with your second point. We've all been there and got the T-shirt

It might sound complicated but it really needn't be. The simplest way is just to open a workbook and then record a macro to make the changes.

Then open all the workbooks one by one and just run the macro.

It won't be a pretty macro and will contain much longer code than strictly necessary but it will do the job. Afterwards and as an exercise you could then review the code, deleting all the stuff that's irrelevant and add some code that would automatically select your workbooks, open them, make the changes and then save and close them.