Forum Discussion
Issues Trying To Export Resource Usage Info From Project To Excel
I am trying to export the resource usage info for my project to MS Excel so people who don't have Project can view this information. The left pane which displays the Resource Name, and assigned task...
Is there another way? Yes. Are you up for some VBA? I've done this many times over the years for many users so it's likely I already have a macro that can give what you want.
Would you be willing to send your file to me along with the details on exactly what you want to see? I will ask some questions.
John
Really? VBA would be required to get extract the Resource Usage View info to Excel? I guess if you want to give it a try. Here is the link to the MS Project File. What I'm looking for is to be able to export the information displayed in both panes of the resource usage view, including headers to Excel. Here is the link to the MS Project File.
https://drive.google.com/file/d/1fW4Y-BdlY4xGIm7iRP8pWQcxKM8rWM-o/view?usp=sharing