Hello Joe.
Perhaps before writing a macro, you could test whether the information displayed in the Resource Usage view is useful for what you are looking for.
You can try the following:
1. From the Resource Usage View, select: Peak Units in the Menu Resource Usage Format > Details > Add Details > Usage Details > Peak Units (Avaliable fields) > Show >> OK and deselect Work. Although the Work field may also be useful to you.
2. Choose the time scale for the resource unit values you want to display in: Menu View > Zoom > Months, for example.
3. If you want to hide the assignments and only see the Resources: Select all the resources by clicking in the upper left corner of the table (above 1), and then Menu > View > Data > Outline > Hide Subtasks.
4. Copy and paste the table on the left into Excel, selecting in the upper left corner (above 1) and Ctr+C to copy and paste in Excel.
5. Repeat the Copy and Paste by selecting the Time Phase on the right, clicking in the corner of the phase (Details) and Ctr+C to copy and paste in Excel, below, in row 2.
Some sample images are attached
Notes:
- The numbers of units shown are the maximums of the chosen periods of the time scale.
- The date header of the time scale is not copied to the clipboard, so you must generate it in Excel.
If this procedure does not work for you, then you can make a macro that requires some experience, especially for this case.
I hope I've helped.
Ignacio
