Excel to ICalendar

[CAM]

Head of IT has given me an interesting task, to write a macro to convert the school calendar to iCal format to put into Outlook.

 

Currently it is in an Excel spreadsheet and I've done a bit of work with macros before to shade cells in different colours for reports. But has anyone ever tried to do this? I assume I have to capture the data, build it into one huge variable and dump the contents in a text file somewhere?