I have a series of data points being consolidated from various sources into one excel file. I would now like to grab task information out of at least 20 different MS Project plans dynamically based on the project chosen on my main sheet of the Excel workbook.

What I need help with is pretty basic. How do I use VBA to open a project plan and grab task information from it? I don't even know where to begin!

If I can just get the basics of how to get to the data in the project plan... I'm pretty sure I can figure out the rest!

Thanks in advance for any help!
Alona