• UseTemplate Add-in

    Templates Addin
    This addin was created to increase the functionality of Excel, and make it easier to use templates in the MS Office system. I use a lot of templates, and got tired of having to make up to six clicks to open one. Now, I have a menu that holds all of my MS Office templates (not just Excel), only three clicks away.

    • Adds a menu to hold all Excel, Word and Powerpoint templates.
    • Open any MS Office template right from Excel. (No more guessing what application you built it in!)
    • Adds a separate submenu for each folder in your templates directory to keep them organized.
    • Groups all templates in your root templates directory in one folder.
    • Supports both network and local templates.
    • Allows you to change your template directory from Excel. (Previously only available through Word.)
    • Toggle button to switch between Edit and Normal modes. (Edit mode opens template for editing, normal creates a new document based on the template.)

    Versions Supported:
    Excel 97, 2000, 2002(XP) and 2003.

    Screen Shot:

    The download package includes the latest version of the UseTemplate add-in, as well as three (very bare bones) sample templates so that you can test the application.

    The current release, (v1.007 from May 3, 2007,) can be downloaded by clicking the button below:


    For a complete set of instructions on how to install and use this add-in, please visit the UseTemplate Add-in Instruction page.

    I'd like to thank Bob Phillips of www.xldynamic.com for helping me make this file compatible with Excel 97.
    Also, I'd like to thank my beta testers for putting this through some paces for me. They are:
    • Zack Barresse
    • Steve Lucas
    • Matt Vidas


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts


    Auto fill web form

    I am close to completing the macro I need to auto fill a web form. I understand the basics of the code and how they reference the html elements but I...

    Eflats1 Today, 01:25 PM Go to last post

    Pivot table and date groupings

    No toe stepping here. I am at the early stages also. And as we already know, there are many ways to accomplish the same result in Excel. Glad to see...

    alansidman Yesterday, 10:32 PM Go to last post

    Pivot table and date groupings

    I don't mean to stand on other's toes - I'm getting to grips with Power Query etc. and wouldn't mind some feedback.
    I experimented and ended up...

    p45cal Yesterday, 08:14 PM Go to last post

    Hiccups in exporting data to Excel from Notepad

    …and I did it with a macro. See attached with a button which runs the code below. It adds a new sheet to the workbook.

    Sub blah()
    Dim Headers()

    p45cal 2019-05-17, 07:26 PM Go to last post

    Hiccups in exporting data to Excel from Notepad

    Using Power Query, I uploaded your text file and then applied the following Mcode

        Source = Csv.Document(File.Contents("C:\Users\alans\Desktop\usergroup.txt"),[Delimiter=",",

    alansidman 2019-05-17, 07:08 PM Go to last post