1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Force Excel Template

Discussion in 'Microsoft Office Specialist (MOS)' started by Boycie, May 9, 2008.

  1. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    I am aware that by placing a workbook in the;

    C:\Program Files\Microsoft Office\OFFICE11\XLSTART directory will make excel use the template on opening, but does anyone know of a way to avoid the File > New > Templates on My Computer (screenshot attached)? The idea being, users have no intervention and a company template is enforced.

    Office 2003, Active Directory Network

    I have looked through the Office and adm templates (links below), but cannot see a way to do this.

    Any suggestions greatly received!

    http://office.microsoft.com/en-gb/help/HA011513711033.aspx

    http://www.microsoft.com/office/orkarchive/2003ddl.htm

    http://support.microsoft.com/kb/816662

    Thanks
     

    Attached Files:

    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  2. Stoney

    Stoney Megabyte Poster

    731
    23
    69
    Do you want them to not be able to create or use a new template, or just from being able to use another template?
     
    Certifications: 25 + 50 metre front crawl
    WIP: MCSA - Exam 70-270
  3. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    Stoney,

    Thanks for your reply.

    The idea being, one template is used across the company (so, i suppose if it would work by preventing them being created - great!) and there is no user intervention when selecting File > New - a new workbook appears with the company template and not asked where to look.

    Simon
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT
  4. Stoney

    Stoney Megabyte Poster

    731
    23
    69
    You may be able to do it using a macro;

    Workbook.Add(Template=:".")

    Not sure how you'd get the Macro to run in every instance of excel?? :blink

    Actually I think that may save the workbook as a template rather than opening a specific template!
     
    Certifications: 25 + 50 metre front crawl
    WIP: MCSA - Exam 70-270
  5. Boycie
    Honorary Member

    Boycie Senior Beer Tester

    6,281
    85
    174
    Thanks for your help Stoney.

    I will let you know what happens.
     
    Certifications: MCSA 2003, MCDST, A+, N+, CTT+, MCT

Share This Page

Loading...