I wrote an article on CodeProject about a C# .Net windows application that I developed using Microsoft Visual Studio Tools for Office (VSTO) to read a schedule that is published in Excel and add the events as calendar entries in Microsoft Outlook. The Excel file is published by NASA for each Space Shuttle mission and it contains the schedule of events for the mission.

I published key portions of the code with an explanation of what the functions did, some cool stuff using regular expressions, and about some of the problems I encountered during the development of the program. Converting between time zones was challenging; .Net 2.0 could convert from local time to UTC and back, but not between Central Time and Eastern Time. I had to solve the problem of the transition period, when Daylight Saving Time ends in one time zone.

The CodeProject Article:

http://www.codeproject.com/KB/office/NasaTvSchedule.aspx

The Project Page for NASA Space Shuttle TV Schedule Transfer to Outlook Calendar

http://www.codeplex.com/NasaStsTvSchedule

Ralph Hightower