Graham Mayor

... helping to ease the lives of Microsoft Word users.

Many people access the material from this web site daily. Most just take what they want and run. That's OK, provided they are not selling on the material as their own; however if your productivity gains from the material you have used, a donation from the money you have saved would help to ensure the continued availability of this resource. Click the appropriate button above to access PayPal.

Replacement New Document Interface for Word & Excel

When Microsoft developed Office 2013 with a view to providing Office for multiple platforms, it rather lost the plot when it came to selecting personal templates for document creation on the PC. That was made even worse when Office 2016 came along and made accessing templates even more difficult. The choice was to fall back to the old Office 2003 dialog or access a non-configurable backstage dialog that shows the files in the User Templates folder.

Clearly neither was a satisfactory solution for users who create lots of template, perhaps for different clients, which are kept in different folders.

Then my old friend Greg Maxey sowed the seed of an idea, as so often happens when we bounce ideas off one another, that I could adapt one of my existing add-ins, used to temporarily load add-in templates for the current session, as the dialogs and processes required were similar and I could thus create a new add-in with the minimum of effort - or at least that was the plan.

Like its forebear the add-in can be used to easily select a template from one of up to eight pre-defined folder locations (all of which are easily changed by a configuration utility) available from the Backstage view from the Word File Menu.

This add-in has not been tested in the 64 bit versions of Office, and contains code that will almost certainly not not work in that version.

Microsoft recommends the 32 bit version for Office for most users, even on the 64 bit version of Windows.

When installed as a global template, it adds a button to the start of the Home tab of the ribbon, and in Office versions after 2007 also replaces the 'New' button in the backstage view accessed by the File Menu (see below).

Office 2007, which doesn't have the file menu, has both buttons on the Home tab. The illustration is from Word 2007, but Excel is similar.

Before the process can be used, it is necessary to configure at least one folder that contains add-in templates. When used for the first time, or by a different user, or when the program is updated (should I produce a later version) the Configuration dialog is displayed automatically:

Users familiar with my work will note that I have changed the colour of the dialogs for the Word version of this add-in from my standard green to blue.  This is to avoid confusion with the essentially similar in appearance add-in loader, when both are installed.

The add-in loader is not available for Excel and so for Excel users, the dialogs will appear in my standard green livery. The Excel dialogs are otherwise virtually identical to those of the Word versions shown below.

Enter as many, or as few, folders as required, however at least one folder must be selected. That can be any one of the sixteen available selections (1 - 8 shown; 9-16 are available from the indicated tab). For the sake of aesthetics it is perhaps better to start at the top, but the choice is yours.

Note that it is not possible to select the current default Word startup folder, as the templates in that folder are loaded automatically at Word startup.

Similarly for the Excel version, the Excel startup folder and add-ins folder are excluded.

Click the ? button on either dialog to get context sensitive help.

Once the settings are updated the main dialog can be displayed:

The red button at the bottom of the dialog clears the registry values used by the add-in and should be used before removing and decommissioning the add-in and at any time you wish to start again from scratch.

Select any of the buttons that are not marked 'Unused' and the button text changes to red colour and the list box is filled with the templates from that folder, as shown above

Click any of the buttons marked 'Unused' and you will see another dialog pop up in the middle of the main dialog, which provides the opportunity to associate that button with another folder, and label the button.

Note that while you can add folders to unused buttons, to remove or vary the association you must re-run the configuration from the button in the File Menu.

And that's all there is to it. Select the template you want to use and click 'Create a new document (or workbook as appropriate), based on the selected template' which will then become available, and a new document (or workbook) is created from that template.

- Click here to download both the add-ins



Word select a template add-in

As can be determined from the site, I live in Cyprus, where in the summer months, it is very hot and humid, and old folks like me prefer to stay indoors and make much use of air conditioning.

During such a hot spell in 2017 I found the time to modify one of my existing add-ins to facilitate the selection of pre-configured personal document templates to create documents; something that Microsoft doesn't exactly make easy for users.