Export Excel Task & Date to Outlook Calendar

[bfvmi93]

Hello Everyone!

I am a new member but have enjoyed this site. Great resource! I recently downloaded a basic file that was posted by another user that has a macro scripted to export a task and date to your Outlook calendar. I slightly modified it aesthetically really. The file is attached. I would like to create a tab that has many tasks (construction type tasks) that will be exported to my Outlook Calendar. I have the following questions:

1. Do I have to create a new script or code for each task?
2. Can I specify sub calendars to export the tasks? If I created sub calendars for each project.

Any advice or help is greatly appreciated.

Thanks!

Brandon