My company runs EMS Service for private parties, sports events etc. We are scheduling our tasks with a SharePoint calendar. For each event one has to create a Excel sheet containing time, date, task number, names etc. For busy weekends we have to create about 100 Excel sheets per day . The data is already written in the SharePoint Calendar. Is their a way to access the SharePoint Calendar with a VBA macro and automatically get the desired data in the Excel spreadsheet ?
there are couple of ways to achieve this and already answered on technet