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
32 stars 10 forks source link

how export more task fields? #8

Closed weituo2002 closed 1 year ago

weituo2002 commented 2 years ago

MS Project task have customized fields, how export them?

PopovGP commented 2 years ago

You mean "Text1..30", "Number1..30"?

weituo2002 commented 2 years ago

for example, MS Project have many custom fields for task, I may define a task field named “responsible department ”，I wish to export this task with that field "responsible department" to excel sheet as a colum

weituo2002 commented 2 years ago

That is, more fields except fix fields: Exports task filelds: № Unique task ID Task name Task start date Task end datae Duration Resource names Task predecessors % complete

responsible department Department of collaboration

and so on

PopovGP commented 1 year ago

All customized fields are like any other fields. Made some examples how to do it (see pictures).

01_Choosing_field 02_FieldRenamed_founding_field_ID 03_PreparedProject 04_StartVBACoding 05_VBACode 06_ResultExport