VBA Programming for Microsoft Project

VBA Programming for Microsoft Office Project is a book written by Rod Gill and edited by two fellow Microsoft MVPs for Project: Gary Chefetz and Dale Howard.

VBA Programming for Microsoft Office Project teaches you how to develop VBA macros for Microsoft Project.  In addition, it teaches you how to develop macros that are productive, quick and easy to maintain. To give you a great start in your Project VBA programming, this book provides a number of very productive macros.

I teach you how to write VBA macros for Microsoft Project by explaining how to design, code and maintain these complete and ready-to-use macros. These macros work in all versions of Microsoft Project: from 98 to 2007. They also look like working unchanged in Project 2010 as well.

In the process of learning how the sample macros work you learn many snippets of code that you will find yourself using in most of your macros from now on.

The book is designed to be a workbook to aid in trainer or self-paced learning and is in three sections:

  • Section 1 teaches the VBA common to all Microsoft Office applications and is aimed at VBA beginners.
  • Section 2 is specific to Project VBA and covers the full range of skills you need to automate Microsoft Project.
  • Section 3 is about reading and writing data to Project databases and reporting on your projects in Project Server.

There is no better way to learn Project VBA than by getting your hands dirty working with productive, working code. That this code is built from small blocks of code you can reuse in all your future macros is a big bonus for you and a pathway to rapid learning. rapid learning.

To see some sample modules, Microsoft were impressed enough to post two of the book's modules on their MSDN site HERE.

May this book meet all your needs and may your macros work first time,