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



PHASE I: OUTLOOK TO EXCEL


On September 21, Kitty discovers the only way she can export the data in the Outlook Calendar to another file is by logging on as The Boss. IT provides Kitty’s boss with The Boss’s password. Kitty’s boss gives it to Kitty and that problem is resolved.

Kitty logs in as The Boss and experiments with the Import/Export Wizard in Outlook to generate a usable file of appointment data.

Outlook does not have an option to export to Word, so Kitty tries exporting to an Access database. She encounters a problem because Access does not recognize the exported dates and times as numbers. She also finds that, through a programming fluke, Outlook will not export to an existing Access database. Outlook insists on creating its own database (and overwrites any database it finds with the same name).

Kitty abandons Access and tries exporting to an Excel file instead. After a bit of experimentation, Kitty discovers the following process works:

  1. Log into Outlook as The Boss.
  2. Click on “Calendar” to bring up The Boss’s Outlook calendar.
  3. Select File and Import and Export to start the Outlook Import/Export Wizard.
  4. Select “export to a file”
  5. Create a file of type: “Excel file”
  6. Select folder to export from: “Calendar”
  7. Save exported file as: “CurrentCalendarData”
  8. Map Custom Fields:
    • StartDate
    • Subject
    • StartTime
    • Location
    • EndTime
    • Description


This does produce a usable Excel file so Kitty is overjoyed.

End of Phase One.

Click here to go on to Phase II...

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