Case Problems

Rainbow Staffing

In the following case problems, assume the role of Patsy as she continues to use Word’s automation features to create more efficient documents. You may want to reread the chapter opening before proceeding.

1. When updating the master job list, Rainbow Staffing agents are supposed to update the date and time that the last change was made on the document itself. Sometimes this step gets overlooked. Patsy has decided to create an easier way of doing this by creating a macro that will automatically update this information. She opens a page of the job list saved as wd11xtra03.doc and saves it to her personal storage location as "Job List". She then records a macro called "UpdateDate" that inserts the date in the footer of the document. ( Hint: Use Insert, Date and Time.) Her completed footer looks similar to figure 11.5.

Figure 11.5 "Job List" footer

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=gif:: ::/sites/dl/free/0072471026/26780/WCh11_acq_Image7.gif','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (1.0K)</a>

She saves the document and keeps it open for the next exercise.

2. Patsy tests her new macro. She notices that when her macro runs, the new entry is appended to the end of the previous one. So, she decides to add some code to correct this. She opens the Visual Basic Editor and inserts the following lines of code before the text Selection.TypeText Text:="Last Updated: "

3. Selection.WholeStory

   Selection.Delete

   When she runs the macro now, all previous text in the footer is deleted before the new text is inserted. She saves the document and leaves it open for the next exercise.

4. Patsy wants to make this new feature as easy as possible for people to use. So, she creates a new custom toolbar called "Patsy" that is tied to the job list document. She includes only a button for performing her macro (although she will probably add more later). She changes the name of the button to "AutoDate" and changes the image to a smiley face. (Hint: Right click the button and choose Change Button Image and Default Style .) For now, she docks her new toolbar next to the Formatting toolbar. The top of the application window should now appear similar to figure 11.6.

Figure 11.6 yadda

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=gif:: ::/sites/dl/free/0072471026/26780/WCh11_acq_Image8.gif','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (14.0K)</a>

She saves the document as "Job List — Custom Toolbar" in her personal storage location.