Hi, I've got a spreadsheet that my company uses to create multiple staff schedules. Each time a schedule is created, a csv file is created that i can import into outlook calendar. Currently we make about 35 individual schedules each month, so importing each one into outlook would be a bit of a burden. I was wondering if this could be done automatically with vba directly from excel at the same time that the csv file is created. I'm pretty sure that can be done, but there is more.

The purpose of doing this in the first place is so that all of our supervisors would be able to see all 35 schedules on their company supplied iphones. We have already created an exchange account that we link to each persons phone and outlook so that we can have shared contact lists. So what needs to happen is for the csv file to be imported into the shared exchange account calendars. Is this even possible?