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