One suggestion. Instead of having the user open a template to select which
template to open (wasted operations), have the user click a toolbar icon
which opens a UserForm (similar to the one in my sample download file). On
this UserForm are four radio buttons and a "OK" and "Cancel" button. The OK
button looks for the template file with the same name as the caption of the
radio button in a particular network folder location and creates a new
document based on that template. The sample file I have on my site
(mentioned earlier) will work perfectly for this.
Have you tried looking at the code and modifying it to suit your needs? Do
these template files exist on a network drive/folder for everyone to use?
Since this will include a UserForm, it will be much easier to help off-line.
The trick in my sample is to specify the drive/folder location of the
templates in the code and be sure to name the files exactly the same as the
caption of the radio buttons on the form. For example if your UserForm
says:
"Select the desired form to open and click OK"
Public
Internal
Confidential
Strictly Confidental
[OK button] [Cancel button]
The file names of your templates need to be "Public.dot", "Internal.dot",
etc. It doesn't have to be that way to work in real life, just with the
code in my example. If you are totally lost and need help doing this, I
would be happy to do it off-line. Provide me the following:
1. Drive/folder location where you want to maintain these templates
2. Exact names of the template files
Obviously you would feel much better about what you have accomplished if you
go through my tutorial and modify my download file and do it yourself,
but... Glad to help!