Discussion Locked

DOWNLOAD: Use this template to create an all-purpose calendar in Word

0 helpful
14 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

https://www.techrepublic.com.com/5138-10877-5823670.html

After you take a look at this download, please post your feedback, ideas for improvements, or further thoughts on this topic.

Thanks,
--The TechRepublic Downloads Team

14 replies

by wattsnew

I belong to a group that meets every Friday and every Sunday of the month. We require that those who cannot attend on any given Friday or Sunday write their names down on the calendar square for each applicable date when they won't be coming. It would be nice to be able to create a calendar that shows only the Fridays and Sundays of each month, along with their appropriate dates. Can anyone think of a way to do this?

by doulos8

You could probably modify the base table in this template and the VBA code as well. But since I don't know Word templates or VBA myself, I would just use this template to create a full-month calendar. Then I'd build a macro to delete the Monday thru Thursday and the Saturday columns. (I found you'd also have to split the header row first and re-merge it when your're down to the 2 days. There were also some other anomalies that I didn't take the time to work out.)

by the officer's mess

Downloaded the calendar.dot - used it.

The number in the box for day 1 was small, centred and not bolded, like the other dates.

Took a look at the macro and the xml - more time is needed than I have as my knowledge of xml is limited.

Another approach would be to ask for a date in the month of the calendar for to print that month and derive all the needed info from that date.. As follows:

Sub Dates()

On Error GoTo bye

CalendarDate$ = InputBox$("First day of the month of the calendar?")
DateIn = cdate(CalendarDate$)
DateFirst = dateserial(cint(format(DateIn,"yyyy")),cint(format(DateIn,"mm")),cint(1))
DateNext = DateFirst + 35
DateNext = dateserial(cint(format(DateNext,"yyyy")),cint(format(DateNext,"mm")),cint(1))
NumberofDays = DateNext - DateFirst
MonthName$ = format(DateFirst,"mmmm yyyy")
FirstDayofWeek = Weekday(DateFirst,vbSunday)
'
' thus from the first question of what day in the month for a calendar of that month, you get the following variables:
' NumberofDays - the number of days in the month
' MonthName$ - month name (note that I included the year, something essential)
' FirstDayofWeek - equivalent of clicking on the box in the table representing same
'
' using this method only one question/action is needed to create a calendar for a given month.
'
For Count = 1 To NumberofDays
Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, Text:= _
"SEQ Date", PreserveFormatting:=True
Selection.MoveRight Unit:=wdCell
Selection.MoveLeft Unit:=wdCharacter, Count:=1
Next Count
bye:

by doulos8

You have to click in the upper right corner of the first day of the month, not in the center of the cell. (Use Show/Hide to see the paragraph setup in the cells.)

by englishteacher

Okay, my programming knowledge is very limited, so I'm sure this is probably a simple fix, but I can't figure it out.

I need to create a calendar for the whole school year, but when I paste together multiple months, the numbering is continuous (e.g., October starts with 31 instead of 1, November with 62, and so on). I really want to be able to have the whole calendar in one document.

Is this an easy fix? If so, what change do I need to make to the code?

Thank you.

by pcchallenge

I would like to have my calendar week start with "Monday" instead of Sunday. Is this easy to change. Thanks for the tip!

by jodygilbert

Hi,
All you have to do is open the template and edit the row with the days in it. To do that, right-click on the template file and choose Open from the shortcut menu. When the template opens, just replace Sunday with Monday, Monday with Tuesday, etc., until the row is re-labeled the way you want. Close the template and save your changes, and now when you create new calendars, the days of the week will reflect the changes you made. Please let me know if you need any additional info.

Jody Gilbert
TechRepublic Downloads Team

by pcchallenge

Many thanks for taking the time to reply. Have done what you suggested and it works perfectly.

Many thanks!

by mvfriar

I tried putting this template into my template folder and creating a calendar/doc using this as my base template. Problem was, no Dates toolbar shows up. Am I missing something?

mv

by jrothaz

I'm having trouble setting up the Outlook calendar so that 2 of us can share it in a Dr's Office for setting appointments. Can someone give me help getting it set up or is your calendar "shareable"?
thanks

by devans00

Not the most user friendly template on the planet. It took me a few times to "get it" and I still didn't get the results I wanted.

First time, I opened the file directly and was prompted to open as read only which I did. Figured that was wrong.

Second time, I opened the file through the File | New | From and existing document | Create New dialog boxes. At least this time I knew not to open the file as Read Only, even though I was prompted to do so. I immediately clicked on the Dates toolbar since it was front and center. Entered 28 for February 2006 then saw the calendar dates flow through the page starting at the Month Name. Not good.

Third time. Repeated all the steps of second time, except to make sure I had the cursor on Wednesday of the first week, for February 2006. This time, I got a teeny little, left justified number 1, but the other dates look OK. Guess I still had the cursor in the wrong place when I ran the Date toolbar macro. I was happily able to modify the Month Name to February 2006 and delete the last line of the table, so the experience wasn't all bad.

I guess once people know what not to do, the template can be a useful tool

by doulos8

I would think you want to open read-only, as you don't want to change the template. But I'm no Word guru so I could easily be wrong.

You do need to know to click in the upper right corner, because that's where the date will go. The small-font line after that is for entry of the days' appointments or notes.

I find it works best when the template first opens to write the month name over Month Name, move the cursor to the first day (upper right corner), and then run the item on the Dates toolbar (or run the Dates macro). It's not real robust or self-documenting, but that was the premise of the original description.

What did you have to delete of the last line of the table? The 6th week? That's just February, or any 5-week month I suppose. Chances are good you'd want a 6-week format for all months just for consistency of appearance.

by allouttr

Hi Jody,

Nice calendar template.

By the way, do you know a good method for preventing a template from being pirated?

JJ

This discussion is closed to new replies.