The Great Calendar Project Journey to a Solution
The Story of A Journey: The Journey Begins Phase I: Outlook to Excel Phase II: Cleaning Up the Excel Data Phase III: Call In the Experts Phase IV: Making It Goof-Proof Phase V: A Test Run and More Goof-Proofing Phase VI: Fine-Tuning Trouble In Paradise Credits and Thanks Home	In mid-September, 2004, as our story opens, Kitty spends a week sitting in for the assistant to The Boss. She discovers, to her horror, that there are FOUR calendars floating about the Office. Calendar 1 is The Official Calendar: a Month-By-Month calendar in which the Assistant writes, in pencil, all appointments. Calendar 2 is the electronic calendar maintained in Outlook 2003 on the Assistant’s computer. The Assistant’s assistant (The Kid) is responsible for transferring the appointments from Calendar 1 to Calendar 2. Calendar 3 is the Word calendar. This is a document maintained in Microsoft Word by The Kid. The Kid is supposed to regularly update the Word calendar so it reflects additional personal appointments made by The Boss himself and new additions to The Official Calendar. These updates are entered manually. Calendar 4 is The Boss’s hard-copy calendar. The Boss does not like computers and does not use computers. He insists his staff produce for him on a regular basis a hard-copy version of his calendar which he can take home. The Boss and Mrs. Boss use this hard-copy calendar for planning their own personal appointments. They write their appointments in by hand on the hard-copy. In theory, The Boss gives his annotated version of his calendar back to The Assistant so she and The Kid can update the other three calendars. Kitty demonstrates to her boss that, at any given point in time, it is probable that the four calendars don’t agree with each other and that this is a disaster waiting to happen. Kitty and her boss decide to do away with Calendar 1 and Calendar 3 and to treat the electronic Outlook calendar as the Bible. Kitty and her boss print out a six-month version of the Outlook calendar as a substitute for Calendar 4 but The Boss doesn’t like that version. He prefers his old Word document. Thus begins Kitty’s Great Calendar Project – figuring out a way to produce a Word document hard-copy calendar that matches as closely as possible the information in the Outlook calendar. Click here to go on to Phase 1...	Some VBA Code: All Macros CompareDates DeleteFakeTimes Empty A ForgetThePast GetDate ImportCalendarData KillB ReplaceApos SaveMyFile (v. 1) SaveMyFile (v. 2) SortDateTime SuperMacro Other Stuff Calendar Template (Excel file) dbCalendar.mdb (Access database) Report Screenshot
A KittyTours website maintained by Jean K. Rosales, Ph.D. Comments, corrections, and suggestions should be sent to webmaster@kittytours.org © 2004 kittytours.org, All Rights Reserved