The function began life as a solution to a user query about changing the dates on a Microsoft template, but quickly changed direction to become the following.
Extract the template from the zip file to the Word Startup folder.
The default startup folder location can be quickly located (in
English language versions of Windows), by typing
%appdata%\Microsoft\Word\Startup in the address bar of Windows Explorer. The illustrations below are for Windows 7, but earlier versions are similar. If you have changed the startup folder from Word Options > Advanced > File Locations then use the changed address (and set the changed address as a trusted location. The original startup folder is trusted by default).
The add-in adds a button to the Add-ins tab of the ribbon as follows. The zip file also includes a self extracting installer, should you prefer to automate the installation, and a set of workbooks containing holiday information that you may use or edit.
Clicking the 'Create a Calendar' button opens the following dialog, the functions of which are self evident. The calendar allows the selection of any year from five years before the current year to ten years following the current year.
For years outside the range of the drop down selector, simply type the year in the box.
Click 'Create Calendar' to create a calendar with each month to a page :
By checking the 'Small format calendar' check box the add-in will create calendars with three months to a page:
Check the Month option and the dialog changes as follows. The current month and year are selected by default, but you can choose any month from five years before the current year to ten years after. As with the year calendar, years outside the range of the selector can be typed into the box.
Click 'Next' and a calendar for the selected month and year is produced as follows.
Prompted by a user's question in a Microsoft forum, who wanted to list his groups' birthdays in a calendar, I thought it might be a good idea to include an option to add birthdays or other data to a month calendar or large format year calendar created by the Create Calendar process.
The process detects whether the active document is a valid month or year calendar (or incompatible) and processes (or not) accordingly.
To use the function, it is necessary to create and save an Excel worksheet, containing at least two columns with a header row. The first column of the table will contain the date. The second column will contain text associated with the date. Any other columns are not used.
Sort the dates on the date column for speed. The illustrations below are from worksheets included in the zip file linked at the end of this page.
On running the process the user will be presented with a userform from which the Excel data file and the worksheet that contains the data must be selected. The add-in provides some basic error handling to ensure that the format is valid, before inserting the data against the appropriate dates, but it can be fooled, resulting in an error condition that is trapped with a warning message.
Select the worksheet and click Add data to the calendar. Names inserted are separated by a comma and a space (see for example the 30th January in the following illustration).
This page features an add-in solution for creating perpetual year calendars, three months to a page; and month calendars, one month to a page, for Microsoft Word 2007 and 2010 (not the 64 bit version of Word 2010).
Alongside the calendar function is a separate process to add data from an Excel worksheet to the calendar, for birthdays, holidays etc.