I have 12 active projects that I am managing in MS Project. Each project has it's own MS Project file and they are located in in differnet folders. What I would like to do is read the overall project "% Completion" field (cell) from each project into an Excel spread sheet. This way I can track the overall completion rate for each project by looking at an Excel file instead of having to open each project.

Is there a way to read from one cell in MS Project and have it popluate an Excel file?

Thanks, Ken