Useful Macro for Microsoft Project 

Kishore

(September 2002)

During my project management experience I have learned to use Microsoft Project Tool. I had learned how to effectively use this tool and make best out of it. During its usage I found MS Project's feature of saving the project as HTML file not quite usable. I have developed a macro which has some simple advantages compared to the default option provided by the tool.

Old Format:

This is a sample HTML file saved by using default option of Microsoft Project.

• This HTML page does not indent the tasks as per hierarchy defined in the project

• Default font and colors are not pleasing

• It is not possible to save Notes along with task

• Task Assignments are always exported in this sample.

New Format:

To overcome the above problems, I developed this simple Macro in MS Project which generates HTML page report that can be published on intranet.

This is sample HTML file created using the tool:

• Tasks are indented based on the hierarchy of tasks

• Font and colors used are different and can be changed.

• Notes is also displayed for each task when applicable. It is available as tool tip and also at end of the page (useful when printed)

• Only required information is exported compared to default format.

Click here to view and copy the Macro code. You can use this if you find it useful.

If you found any bugs or would like an enhancement do let me know.