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	This is the story of how the routine and boring assignment to produce a hard-copy calendar for a demanding boss turned into an exercise in ingenuity and a learning process. Much of the credit for the ultimate success of the project is due to liberal use of: Experts Exchange a great website to consult if you're looking for assistance on almost everything related to computers and programming. Specific credit for generous help, patience, and ingenuity goes to the Experts: bruintje brettdj roos01 MalicUK jevreist matthewspatrick DRJ ShaneDevenshire byundtd Without them, none of this would have been possible. Click here to begin the narrative...	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