search

PopovGP / Export-MS-Project-to-MS-Excel

Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
GNU General Public License v3.0
31 stars 10 forks source link

how to export resource using with gantt chart to excel? #1

Closed wuzhenda closed 3 years ago

wuzhenda commented 3 years ago

rt

PopovGP commented 3 years ago

This module exports column "Resouce names". If it is filled in your MS Project file, it will be exported.

wuzhenda commented 3 years ago

yes. but we want to seperate each human resource to see their task load. I'm trying to modify your script.

PopovGP commented 3 years ago

Could you describe how it should look like? You may draw some sample by hand.

wuzhenda commented 3 years ago

image sth like this. I generated the image use your script,and manually modified some items.

PopovGP commented 3 years ago

PersonB is working on several projects, which are in separate files? ProjectDetail is a task name?

wuzhenda commented 3 years ago

No. ProjectA and ProjectB are the top level projects. ProjectDetails are the second level projects. They are all in the same file. I use the sub level projects to show project milestone.

wuzhenda commented 3 years ago

which I want to implement is sth like the "Resource Using View",but use gantt chart instead of the the right part of the view, and export to excel.

PopovGP commented 3 years ago

I understand now how it should look like. Sorry, at present it's not implemented and you should try do it yourself. I can do it, but later.

wuzhenda commented 3 years ago

OK.I'm trying now.

mhykol2k commented 1 year ago

@wuzhenda Did you get this sorted, we are having the same issue

wuzhenda commented 1 year ago

@wuzhenda Did you get this sorted, we are having the same issue

yes,I modified and fit my needs. https://github.com/wuzhenda/Export-MS-Project-to-MS-Excel

but since two years passed and this repo has added some commits, sth maybe tested again.