Creating the Program Count Calendar

This procedure will create the calendar used to enter program counts at the Reference Desk. It requires that macros (Find Replace and Paste Text) be installed in the Microsoft Word program on your computer. These can be found in the Forms folder on the network drive (ProgramCalendarMacros.bas).

* Open Program Count Calendar form. (J:\Forms\Program Count Calendar.dot)

* Enter appropriate dates and title.

* Open Program Calendar in Internet Explorer from the staff page to the desired month.

* Limit types to Adult, Young Adult and General Audience. Click on check mark.

* Select all on first date to be copied to calendar. Copy entries from the list on the right
side.

* Click inside corresponding date in Program Count Calendar form. Click “Paste Text”
function. Continue this process until all days required are complete.

* Click “Find Replace” function.

* Check for correct formatting and accuracy.

* Highlight programs where required