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:
- Download and open 'Empty_MS_Project_with_macros.mpp'
- Allow Visual Basic macros when asked
- Open project file you want to export
- While in your project file, choose the View tab, click Macros
- Choose 'ExportExcel'
- Click 'Run'
Exports task filelds:
- №
- Unique task ID
- Task name
- Task start date
- Task end datae
- Duration
- Resource names
- Task predecessors
- % complete
Exports those resource list fields:
- №
- ID
- Code
- Name
- Initials
- Group
- Base
- Calendar
- Booking Type
- Email
- Address
- Standard Rate
- Overtime Rate
- Peak
- Max Units
- Type
- Cost
- Cost Per Use
- Overtime Cost
Examples:
1.1. Project file:
![Project screenshot](https://raw.githubusercontent.com/PopovGP/Export-MS-Project-to-MS-Excel/master/Samples_and_Images/Initial_project_example.png)
1.2. Excel file:
![Excel screenshot](https://raw.githubusercontent.com/PopovGP/Export-MS-Project-to-MS-Excel/master/Samples_and_Images/Result_excel_example.png)
2.1. Project file:
![Project screenshot](https://raw.githubusercontent.com/PopovGP/Export-MS-Project-to-MS-Excel/master/Samples_and_Images/Initial_resourcesheet_example.png)
2.2. Excel file:
![Excel screenshot](https://raw.githubusercontent.com/PopovGP/Export-MS-Project-to-MS-Excel/master/Samples_and_Images/Export_resourcesheet_example.png)
3.1. Project file:
![Project screenshot](https://raw.githubusercontent.com/PopovGP/Export-MS-Project-to-MS-Excel/master/Samples_and_Images/Initial_calendar_example.png)
3.2. Excel file:
![Excel screenshot](https://raw.githubusercontent.com/PopovGP/Export-MS-Project-to-MS-Excel/master/Samples_and_Images/Export_calendar_example.png)
Notes:
- Created for MS Project 2019 Professional.
- If errors found - please write me or do your branch and correct.
- Supports all languages.
- Dates are formatted using system locale settings.
If you want to use it in another project:
Use "ExportExcel.bas"
- Launch MS Project
- On the View tab, click Macros, and then click Visual Basic
- In ProjectGlobal right-click in Modules
- Click 'Import file' and choose 'ExportExcel.bas'
- '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.