Forum Discussion
Exporting Project - Resource Usage table with phased time data to excel
Hi Experts, Is there a way to export tasks to excel while retaining the phased time cost data? In an ideal world I would like to export this info and for it to look like this in excel: ...
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.- FischerJack,
You're welcome and thanks for the feedback.
John