Export MS Project Gantt chart to MS Excel

MS Visual Basic module to export tasks, Gantt chart and resources list from MS Project to MS Excel. Cute output. 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-levels' 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 side 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's fields:

1. №
2. Unique task ID
3. Task name
4. Task start date
5. Task end date
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 found or you have a comment - feel free to write.