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 ?
If you have added all the dates and tasks to your SharePoint Calendar, you can go to the Connect & Export settings and export all the information into on Excel spreadsheet. I use this method often! it has saved me hours of work.
hope this helps!
there are couple of ways to achieve this and already answered on technet