Currently, our schedules are available on the internet and can be exported
into excel. Is there a way to run a macro from excel that would create the
schedule in outlook calendar. As our schedules are constantly changing, is
there a way to remove selected old items or rwould it be best to create a new
folder in Outlook calendar to import these items to, that can be deleted and
recreated with every import? Would it be best to take the date from excel
and run a macro in excel to format it for notepad, copy it into notepad and
then save as a .ics or .vcs file and import? So far I have been able to call
outlook and create a new calendar folder, but have had trouble getting the
data into the folder.