Forum Discussion

Copper Contributor

Jan 23, 2024

macro to export resource usage information

Hi! I am new to MS Project and would like to write a VBA macro for Project to write an excel of peak units for each resource by month for a given date range. The goal is to use this date in a Power...

vivekkumar10

Copper Contributor

Oct 21, 2024

John-project

Hi John,

I'm using Project 2016 Standard, and have Excel 2013, I need to create a report for management based on MS Project data real time (on save MSP), highlighting critical tasks, issues & delays from baseline. could you please help, as I feel I'm stuck with the inbuilt export & it does not give me hierarchy of tasks as each column, rather task name is the only column export using wizard.

I came across your previous answers and found them really useful, but those threads were locked (long ago), could you please help solve my issue.

Many thanks,

John-project

Silver Contributor

Oct 21, 2024

vivekkumar10

This really should be a new post instead of tagging unto an existing post. I suggest you post a new question with a little more detail on exactly what you are trying to do (a screen shot mock up of the report you want would be very helpful). Then me or one of my colleagues will be in a better position to offer help.

John