How to update the year on calendar template?

[EFITS]

Many thanks to all the template creators!!

I have downloaded a 2007 calendar template, how do I 'resue' it for the
following years?! Or even previous years?

Or do I need to return here to download another calendar template for 2008,
2009...? The only problem is I have customerized the one I have downloaded
and hate to redo it for every year again?

 

[Beth Melton]

You could modify your calendar for 2008 but that would take a lot of work.
The calendar is just text - it doesn't automatically update. You'd have to
move the days and 2008 is a leap year so you'd need to accommodate that as
well. Since you customized your calendar then either way will take some
work. Decide which method would take the least amount of work and us it.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[EFITS]

The Calendar Wizard in Word permits a date range selection. There are three
types, Boxes, Banner, and Jazzy. I am able to create calendars for future or
previous years, just not the format or layout I like.

Maybe I can add my customerized calendar to the wizard?! Or replace one of
them? I have searched on Help and the instructions given to create a wizard
template was not easy to follow. I have trouble understanding it.

BTW: When I save my customerized calendar, I do not see '.dot' in the File
Save As Type drop down list? I have to save it as .doc, and then rename it as
..dot?!

 

[Beth Melton]

If you are using the Calendar Wizard then this was created using VBA and the
entire calendar creation is written in VBA. IOW, there isn't a base template
that is used that can be easily modified. Once the wizard is complete then
the resulting calendar is just text, it doesn't automatically update.

What types of modifications did you make? Did you check Office Online for
other calendars? http://office.microsoft.com You might find one there that
will fit your needs.

As for designing your own wizard, that requires quite a bit of VBA
knowledge. You could create your own Calendar template, I suppose you
could use Word formula fields for your Calendar that look to the previous
cell and add 1 to the value. Then you could just modify the cell for the
first day of the month and update the other formulas, but even that might
take some work. Although, maybe you could create a single month and
copy/paste it for the other months?

I'm not sure why you aren't seeing Word Template in the Save As type list,
but changing the extension of a .doc file type doesn't exactly make it a
template. Is there a reason you need a .dot file type? Note that Word will
allow you to create new documents based on documents.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[EFITS]

I did get the '2007 calendar with room for notes' template from this site and
modified it to the way that is more useful for me.

I did not know the templates in the wizard is written in VBA. I saw the .dot
file extention, so I thought if I placed my .dot file to the same wizard
directory I could use it. According to answers I found in Help, I was told to
save it as .dot. (Just to show you how little knowledge I have in templates).
I do not have VBA or know how to use it.

So it seems there is no 'easy way' around for me to use my own customerized
calendar template for future use without having to do a lot of editing for
each calendar year :-(

In regards to 'customerized' it is basically changing the cosmetic look of
it - I took out one of the note table, re-align the columns, change the font

 

[Beth Melton]

You could certainly try to modify a copy of your current calendar to see how
much effort would be involved. What I was referring to was for each date you
would need to insert a formula in the table cell (used to create each 'day')
such as =A1+1 and in the next cell, =B1+1, and so on. But after taking a
look at the template you are using it also has the Day number so the formula
method may not work.

You might try your hand at macros. What you describe could be recorded as
you modify the first month and then played back on the rest of the months in
the calendar. Although trying to use the macro recorder on a table might
prove difficult.

Actually, the changes you are making shouldn't take that long - perhaps the
methods you were using weren't the most efficient? For example after you
delete the notes table, click in the next notes table and press F4 to repeat
your last action. The same method can be used for Saturday and Sunday
columns: make the change once, select the next column, press F4.

Then for re-aligning the columns, change the boundary for the right table
border, select the table and then use the Distribute Columns command (on the
Tables and Borders toolbar) to evenly space the columns to the new table
width. For the font changes, these can be quickly modified by changing the
Style.

For the latter, go to Format/Styles and Formatting to display the Styles
task pane. Make your desired formatting changes once. Then in the Style task
pane, hover your mouse over the selected Style, click the down arrow that
displays, and then click "Update <style name> to match selection". All
occurrences of the text that is associated with the style should update and
reflect your change. Do the same for other formatting you want to change.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[EFITS]

Thanks for the great tips, sure makes the editing much, much easier. Learned
these many years ago in a Word class and have total forgotten them.
Definitely need to brush up on the Style functionality.

Thank you very much.

 

[Beth Melton]

I'm glad something finally helped! <grin>

Yes, Styles are indeed the key to quick formatting and quick formatting
changes.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/