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).

Export-MS-Project-to-MS-Excel

MS Visual Basic module to export tasks, Gantt chart and resources list from MS Project to MS Excel. Instant use. No setup required. 100% MS Project VBA.

Features:

• Versatile
• Exports all commonly used fields
• Automated nice Gantt-chart in Excel with color and border emphasizing
• Tolerant to blank fields
• Eight-level's row grouping (MS Excel maximum) with different fonts
• Support unlimited levels of indented tasks in MS Project
• Automatically indents subtasks and does grouping
• Gantt chart is created at right site of the sheet

Using:

1. Download and open 'Empty_MS_Project_with_macros.mpp'
2. Allow Visual Basic macros when asked
3. Open project file you want to export
4. While in your project file, choose the View tab, click Macros
5. Choose 'ExportExcel'
6. Click 'Run'

Exports task filelds:

1. №
2. Unique task ID
3. Task name
4. Task start date
5. Task end datae
6. Duration
7. Resource names
8. Task predecessors
9. % complete

Exports those resource list fields:

1. №
2. ID
3. Code
4. Name
5. Initials
6. Group
7. Base
8. Calendar
9. Booking Type
10. Email
11. Address
12. Standard Rate
13. Overtime Rate
14. Peak
15. Max Units
16. Type
17. Cost
18. Cost Per Use
19. Overtime Cost

Examples:

1.1. Project file:

1.2. Excel file:

2.1. Project file:

2.2. Excel file:

3.1. Project file:

3.2. Excel file:

Notes:

1. Created for MS Project 2019 Professional.
2. If errors found - please write me or do your branch and correct.
3. Supports all languages.
4. Dates are formatted using system locale settings.

If you want to use it in another project:

Use "ExportExcel.bas"

1. Launch MS Project
2. On the View tab, click Macros, and then click Visual Basic
3. In ProjectGlobal right-click in Modules
4. Click 'Import file' and choose 'ExportExcel.bas'
5. 'ExportExcel' module should appear in modules

This module is provided 'as-is' and comes with no warranty. If any error or comment - feel free to write.

export-ms-project-to-ms-excel's Issues

Export Gantt Chart in time intervals other than days

Hi, I would like to export a Gantt chart from my MS Project using this macro, unfortunately it only lets me export in days despite the project settings being quarterly or monthly.

Please let me know if you have plans to accommodate this addition to the script.

• Mike

Change license to GPL

• Change to GPL license

Add calendars export

• Add calendars export.

Add resources export

• Add resources export.

how to export resource using with gantt chart to excel?

rt

how export more task fields?

MS Project task have customized fields, how export them?

Add resource assignment

• Add resource assignment export.

Add properties export

• Make properties' export

Option to change gantt view from weekly to monthly or quarterly etc

It would be excellent if the user could select the period for the gnatt view from being weekly to Monthly, quarterly etc.