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

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

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

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

In article ,
"Ron de Bruin" wrote:

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

Ron,

Yes, I see how your template does what you wrote above. Nicely done.


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

No, I wish to be able to install a complete .xlt workbook,
(not a sheet only). ********

I could not figure out how to change your sheet-template-installer
routine, to make it a workbook-installer-routine.

Would you coach me how to change your code for this?
I have spent time trying to alter the code.

I can imagine that using some bits of your code, that I could copy parts
of the code into a seperate workbook that would install my main template
and in that way I could get around the newly created file self-deleting
itself.


Thanks for your attention.

-Dennis





--
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



--
Dennis Kessler
http://www.denniskessler.com/acupuncture

Hi DK

Not tested but try this

Create a new workbook (named install.xls) and copy this code in the thisworkbook module

Private Sub Workbook_Open()
If Dir(ThisWorkbook.Path & "\your.xlt") < "" Then

Name ThisWorkbook.Path & "\your.xlt" As Application.TemplatesPath & "\your.xlt"

With ThisWorkbook
.Saved = True
.ChangeFileAccess xlReadOnly
Kill .FullName
.Close False
End With

End If
End Sub

Now give the user this workbook and the template your.xlt and say to run the workbook to install the template
Both files must be in the same folder.

It move the xlt to the template folder and kill the install xls


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


"dk_" wrote in message ...
In article ,
"Ron de Bruin" wrote:

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

Ron,

Yes, I see how your template does what you wrote above. Nicely done.


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

No, I wish to be able to install a complete .xlt workbook,
(not a sheet only). ********

I could not figure out how to change your sheet-template-installer
routine, to make it a workbook-installer-routine.

Would you coach me how to change your code for this?
I have spent time trying to alter the code.

I can imagine that using some bits of your code, that I could copy parts
of the code into a seperate workbook that would install my main template
and in that way I could get around the newly created file self-deleting
itself.


Thanks for your attention.

-Dennis





--
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



--
Dennis Kessler
http://www.denniskessler.com/acupuncture

Note that this example is for a Sheet template

--
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