MS Project Utils

Utilities for inspecting Microsoft Project MPP files with VBScript, VBA, and Java.

Report summary

Both reports output Microsoft Project file details without saving changes to the MPP file. The report includes:

• File size
• Project properties
• Built-in document properties
• Custom document properties
• Custom field names

Custom fields are printed in this format:

Text1: Custom Task Text
Number1: Custom Task Number
Flag1: Custom Task Flag

Prerequisites

Requires:

• Windows
• Microsoft Project desktop installed
• Access to the target .mpp file
• Windows Script Host for running the VBScript report with cscript
• Microsoft Project VBA access for importing and running the VBA report
• Java 21 and Maven for running the Java console report

Developed and tested on:

• Windows 11
• Microsoft Project Online Desktop Client MSO, Version 2606 Build 16.0.20131.20154, 64-bit

Run the VBScript report

Use vbscript/project-report.vbs when you want to open an MPP file by path, print the report to the console, and close the file without saving changes.

From PowerShell, set the MPP path and run the script with cscript:

$mppFile = "C:\path\to\project.mpp"
cscript //nologo .\vbscript\project-report.vbs $mppFile

Or pass the path directly:

cscript //nologo .\vbscript\project-report.vbs "C:\path\to\project.mpp"

Optionally, to make .vbs files run with cscript by default, open an administrator terminal and run:

cscript //H:CScript

After that, you can run the script without explicitly calling cscript:

.\vbscript\project-report.vbs "C:\path\to\project.mpp"

The script starts or attaches to Microsoft Project, opens the MPP file, prints the report, then closes the MPP without saving changes.

Run the Java console report

Use java/ when you want a console report powered by MPXJ 16.7.0 instead of Microsoft Project automation.

Build and test the Java module:

cd java
mvn verify

Run directly with Maven:

mvn exec:java '-DmppPath=C:\path\to\project.mpp'

Run the shaded console jar:

java -jar .\target\project-report-1.0.0-SNAPSHOT.jar "C:\path\to\project.mpp"

The Java report prints file size, project properties, built-in document properties, custom document properties, and custom field aliases with populated value counts where MPXJ exposes them. Unit tests run with JUnit 5, and mvn verify generates a JaCoCo coverage report under java/target/site/jacoco/.

Run the Immediate Window VBA report

Use vba/project-report.bas when the MPP file is already open in Microsoft Project and you want the report printed to the VBA Immediate Window.

1. Open the target .mpp file in Microsoft Project.
2. Press Alt+F11 to open the VBA editor.
3. In the VBA editor, select the project for the open MPP file in the Project Explorer.
4. Select File > Import File....
5. Choose vba/project-report.bas from this repo.
6. Press Ctrl+G to show the Immediate Window.
7. Run the macro PrintActiveProjectReportToImmediate.

You can run the macro from Run > Run Sub/UserForm, or from the Immediate Window with:

PrintActiveProjectReportToImmediate

The macro prints the report for the active project.