Hi dk

I install a sheet template

The template sheet is in workbook(xls) that you download
The code in the workbook open event copy the sheet to a new workbook and save that as template in the template folder.
Then it delete the install workbook

Do you want to install a sheet template ????




--
Regards Ron de Bruin
http://www.rondebruin.nl


"dk_" wrote in message ...
Ron,

Your installer code is a thing of beauty!

But there is good news, and there is bad news, (for me)....

Is there away that I can delete the install code after my template is
installed. Or, did I do the wrong thing? ...see just below.


The good news...

I double clicked your templates with Excel97--(Windows 98se),
Excel97--(Windows XP), and Excel 98--(Macintosh, OS 9.1).

Your very slick file was installed in the proper Templates folder on all
three machines. Very, very nice!!!

I then copied and pasted your code into one of my templates, in the
'ThisWorkbook' object window.

I changed your filename, referenced in the procedure, to my current
filename and saved my file.

When I double clicked my template file with your code installed into it,
the file was indeed installed in the Template folder. ...Perfect so
far!!!

When I start a new workbook using the File--New menu in Excel, click on
my template, a new workbook is created. I save the new workbook and
close that new workbook. ...Perfect again, so far.


Now the bad news, (for me, anyway)...

When I go to open the newly saved .xls workbook, that workbook runs the
installer procedure again, which is stored in it's 'ThisWorkbook' object
window.

...My new .xls file is not usable, (it closes), and a template is once
again stored in the templates folder. So it goes in a circle.


Would you coach me what to do from here?

I see according to the way that I read your code, that the original file
that I installed from, is supposed to be deleted, (I think), but it's
still there also.


Thank you for showing me, that it can be done! I like the way that you
did your user messages also.

-Dennis

-------------------------------

In article ,
"Ron de Bruin" wrote:

Hi DK

Look at the code in the workbook open event of the install file of one of the
templates
http://www.rondebruin.nl/mail/templates.htm

Disable macro's when you open the file so you can look at the code


--
Regards Ron de Bruin
http://www.rondebruin.nl


"dk_" wrote in message
...
Is there an installer program available, or recommendations on how to
get people be able to put a template file in the appropriate Office
Template folder, (for a small distribution of people)?

...For many people this seems to an impossible or a very intimidating
task, simple as it should be.

Thanks.

-Dennis