Re: Templates

Hi Dave
Thanks for the reply.

Quote
I have no idea what you're doing, but maybe you could use an addin that has
a few macros that do the customization that you want.
Question 1
I wasn't being specific, just seeking suggestions for good practice to
follow regardin the use of templates. I currently used VBA to open the
Template Dialog but this is only on my computer. I am interested in your
suggestion about using an addins.....if you don't mind me asking....what
addins have you found useful?

Quote
I don't see too much difference between a .xlt file and a .xls file that
can't be saved.
Question
I am not sure I understand what you mean by can't be saved.
I use the Xlt extension because it opens as a xls and saves as an
xls...preventing the xlt from being overwritten by other users accessing it
at the same time.
Can you elaborate a little
Thanks


"Dave Peterson" wrote:

#1. For each user who needs to have access to the templates:

Open MSWord
Tools|Options|File Locations tab
And change workgroup templates to what you want.

Excel will use that setting, too.

#2. I have no idea what you're doing, but maybe you could use an addin that has
a few macros that do the customization that you want. Or maybe something in the
auto_open/workbook_open procedure???

#3. I used to weasel on this. I don't see too much difference between a .xlt
file and a .xls file that can't be saved. I would create a .xls file on a
common network folder. I'd mark it as Readonly (using Windows explorer) and
save it marked readonly.

Then I'd keep a backup -- just in case someone deleted that file.

The users would just open the file to use it. Since the file was readonly, they
had to save it somewhere else.


Dermot wrote:

My Current Understanding....correct me if I am wrong.
When saving templates (dot Extension) in either Excel or Word 2003 I can
save them so they appear in the Template dialog box. The Template can be
opened from the dialogue box accessed "Templates On My Computer".
Or
I can browse anywhere within my computer and creat a custom folder to save
the templates.

Question 1
Is there a way to save the templates in a tabbed "Template Dialog" but have
them available to every computer on a network.

Question 2
What is considered the best practice with respect to templates for
multiusers on a network with respect to peronalising for individuals but at
the same time taking into account the possible need for modification.

Question 3
I would appreciate any other suggestions that would be worth considering.

Thanks in advance

--

Dave Peterson

.

Relevant Pages

  • Re: Office Customization Tool for Office 2007
    ... The admin folder is available for download with the "'2007 Office system ... Administrative Template files and Office Customization ... Although the layout of the new templates isn't very tidy once they're ... and why give us a retail key with enterprise edition from action pack? ...
    (microsoft.public.office.setup)
  • Re: Migrating Lists from one server to another server
    ... If you added new templates by copying paths in the C: ... WSS information in C: with the information in your customized C: ... If you amended customized lists or sites then doing Save List as Template ... Site that includes your customization. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Application.CustomizationContext = Application.Customization context is removing my docs toolbar
    ... that their own templates and code is usually not written with safety ... customization context without having set it, ... > to restore an original customization context. ...
    (microsoft.public.word.vba.general)
  • multiple WSS/SPS instances
    ... Most of the sites have gone under heavy customization (themes, css, ... templates, etc). ... image directories for each virtual servers, but all virtual servers took the ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Accesing vba project from wb that has vba project password protected
    ... why not make 1 addin with all the code? ... copy the addin to the server and all your users and templates can work ... > problem is that they all have a password set to lock the vba project. ... > anyway of programmatically passing the password so as to open the ...
    (microsoft.public.excel.programming)