VBA Programming for Microsoft Office Project Versions 98 through 2007 (Emp Learning) (Paperback)

~ Rod Gill (Author), Gary L Chefetz and Dale A. Howard (Editor)

Editorial Reviews

Product Description

Rod Gill's VBA Programming for Microsoft Office Project, Versions 98 through 2007 is the first book devoted to Microsoft Project VBA. Rod Gill helps you get the most from the worlds most popular Project Management tool by showing you ways to automate away the drudgeries of schedule manipulation, how to vastly enhance your reporting capabilities, and how to integrate with other Microsoft Office applications like Access and Excel. VBA Programming for Microsoft Office Project is packed with carefully commented code samples described through a one-step-at-a-time learning approach, each successively building toward more useful and complex application code. With 14 fully functional macros plus many samples of useful code snippets available for download from the official book site, you can start realizing efficiency gains on your very first day using this long-awaited resource. The books editors include Microsoft Project MVPs Gary L. Chefetz and Dale A. Howard, the authoring team who produced the only book on Project Server 2002, and seven titles covering Project and Project Server 2003 including the benchmark standards: Administering an Enterprise PMO using Microsoft Office Project Server 2003 and Managing Enterprise Projects using Microsoft Office Project Server 2003.

About the Author

Rod Gill, founder of New Zealand based ACE Project System Ltd., has been involved with project management his entire career and with the advanced use of Microsoft Project since its first release. Along with project management training, consulting, and Project Server implementations, Rod has a regular sideline in VBA development, mostly for Microsoft Project. Rod was drawn to VBA development and the challenge of integrating Microsoft Project with other systems after 8 years of software engineering. Rod is a long-time Microsoft Project Most Valuable Professional (MVP), first winning this prestigious technical award in 1998 for his contributions to the Microsoft communities. Rod s passion for Microsoft Project and Project VBA and for helping others has kept him in the forefront of using Microsoft Project.

Product Details

• Paperback: 476 pages
• Publisher: MSProjectExperts; 1 edition (October 25, 2006)
• Language: English
• ISBN-10: 0975982877
• ISBN-13: 978-0975982877
• Product Dimensions: 10.8 x 8.3 x 1.2 inches
• Shipping Weight: 2.7 pounds (View shipping rates and policies)
• Average Customer Review: 4.8 out of 5 stars  See all reviews (12 customer reviews)
• Amazon.com Sales Rank: #203,528 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #39 in	Books > Computers & Internet > Microsoft > Applications > Project
  #42 in	Books > Computers & Internet > Microsoft > Development > VBA

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars A great guide to one of Microsoft Project's hidden features, November 15, 2006

By	Jack Dahlgren (California) - See all my reviews (REAL NAME)

Using Microsoft Project just out of the box has a number of limitations. You are restricted to the features that Microsoft decided to include, and you have to accept the way that they designed them. Sometimes this is just an irritation, othertimes it is a major roadblock. But, inside of Project is the ability to use VBA (Visual Basic for Applications) which allows you to do anything that is possible in the application and extend it to add additional functionality.

Unfortunately, Project VBA has been poorly documented and promoted until now. Rod's book is a great introduction to this topic and can get you started on the path to making Project obey your will instead of the other way around. Even if you only use VBA to automate a few repetitive chores or perform some special formatting it is well worth the cost of this book.

In my opinion, Rod's approach (a mix of critical information and tutorial) is an excellent way for people to find their way. The existing documentation on Project VBA can be difficult to work through, so Rod's examples and explanations along with recommended practices are essential to make sense of it in a hurry.

This is the first book I know which is completely devoted to Project VBA. Most of the project "bibles" only cover it in a cursory fashion with a chapter or so. It deserves more than that, and Rod Gill has finally delivered a book which does the topic justice.

4 of 4 people found the following review helpful:

5.0 out of 5 stars Clarity and most of all Completeness, November 11, 2006

By	J. De Messemaeker - See all my reviews (REAL NAME)

The title sais it all, really.
We all know this book is years overdue - there was no book on ythe subject at all - but the waiting wa worth it. It is crystal clear in its explanations and in the examples, but most of all it touches highly important subjects you wouldn't expect: Project 2007, but also links to Access, to the Server DB, and OLEDB.

To me personally this book will serve in two ways:

- It will help me teach Project VBA (I have declined such requests for lack of a good student book)
- It will allow me to develop in areas I have been avoiding (Data Bases and OLEDB)

Thank you Rod, and congratulations.

4 of 4 people found the following review helpful:

5.0 out of 5 stars It's about time we had a book on Project VBA, October 27, 2006

By	John - See all my reviews

Where was a book like this when I started writing VBA macros for
Microsoft Project! It would have saved me many hours of frustrating
trial and error and searches through the Project VBA help file.

The author has pulled together information from Project's VBA help file,
Project newsgroup postings and years of experience with Visual Basic and
Project itself to provide a much needed guide specifically directed
toward Project's version of VBA. The information provided is as good for
someone who is new to Project VBA as it is for someone who already has
good Project VBA experience.

This book is not limited to Project VBA however. It also is a good
resource for those who simply want to customize Project fields using
formulas, value lists and graphical indicators.

Many books on programming use a "hello world" approach to the examples
they present. This book is filled with good practical examples that are
immediately useful to the Project user. If you are a Microsoft Project
user and you want to expand the functionality of the application with
VBA, I highly recommend this book.

John