Forum Discussion
Automatically download dashboards from Microsoft Project
Hello everyone I have a strange question for you users: I have many projects in Microsoft Project. Everyone of them is a Gantt Diagram updated daily. Then I have a main project, where everyone of...
Hello, yes, I'm sorry, I'm using 2021 version.
All the projects are linked to the main project, so in the main you can see a Gantt Diagram of all of them, in a cumulative way. They're not subprojects, I don't know how to explain it but is like they're anchored to the main one. By the way, this info isn't really important at the end.
I can't post a screenshot, since there are sensible informations, but I mean this:
What I want is something that, once you give it the ms project file, it extracts the report in a file that can be consulted (like a jpg or text document, but not like another mpp file). The purpose is to avoid to copy\paste all the plots in another place, and "automatically" obtain the reports plots instead.
f10r3nz4,
You seem to indicate that how the files are linked isn't important, but with Project, that bit of information is very important. If the projects are not subprojects in a master, how exactly are they "linked"?
If you are looking for some method to extract data from MS Project files and produce a report that does not require Project to view I suggest VBA. For example, a VBA macro either based in Project or Excel (for example) could open each Project file, extract the desired data, and produce custom reports/graphs.
John
You seem to indicate that how the files are linked isn't important, but with Project, that bit of information is very important. If the projects are not subprojects in a master, how exactly are they "linked"?
If you are looking for some method to extract data from MS Project files and produce a report that does not require Project to view I suggest VBA. For example, a VBA macro either based in Project or Excel (for example) could open each Project file, extract the desired data, and produce custom reports/graphs.
John