Using VBA for Projects

Microsoft Project is like Marmite - you either love it or hate it.  It can be a great tool for project management but it does have its quirky behaviours and annoyances.  We can get around some of these limitations through extending the Microsoft Project functionality which I try to cover here in these pages.

Tutorials

I have started putting some tutorials together for using VBA with projects.

1. Part 1: Opening and using Project from within Excel
2. Part 2: Working with Projects and Tasks
3. Part 3: Using TimeScaleData with Tasks, Assignments and Resources
4. Part 4: Using event handling with Microsoft Project
5. Part 5: Manipulating view fonts and colours using Select and Find
6. Part 6: Storing values between saving and re-opening an MPP

Please comment below if there are specific topics you want me to cover.