Forum Discussion
Exporting Project - Resource Usage table with phased time data to excel
I'm the John guy Dale referred to and yes I can help you with VBA to export Project timescaled data to Excel. I can write code to create the spreadsheet you show in your 2nd screen shot but I don't think that's really what you want. Look closely. The material resource "boiler floor space" shows 140 square meters which is correctly spread over 4 days in Project's Resource Usage view. Yet somehow, that 140 square meters has morphed into 175 square meters spread over 5 days on the Excel spreadsheet. Details, details.
I've done this very type of export for a ton of users and myself over the years. If you'd like my help with this, I suggest we work one-on-one via e-mail. I will ask some questions. My contact info is below.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies)
- Hi,Saw your post with A.User about vba code to export time phased cost over time from MS Project to Excel but you went off forum to respond. Did you write code to do this?I also have been trying to do this with no success.
Quick answer, yes. When working with special requests from users I find it easier working one-on-one via e-mail rather than trying to hash out all the details on the forum. If you are interested you can contact me at the address provided in my previous response. Tell me exactly what you want and include your Project file if you can. I will ask some questions.
John
- John-project
Thanks for working with me on this topic. You not only answered my initial request, but you determined what my ultimate goal was and included code to facilitate the outcome so that I don't have to run numerous other code or manipulate the data between MS Project and Excel. This is going to make my life much better.
For anyone else looking for a solution to their coding issues, I would recommend explaining not only the code issue(s) but also explain what's your ultimate goal as I not only got my code answer, but a whole lot more.
