« Swimming to Cambozola | Main | And now for something completely different »

Microsoft Project VBA the Rod Gill way

Rod Gill has put out a new book which covers most of what you need for Microsoft Project VBA programming. As far as I know it is the only book about VBA that I know of. The last edition of Tim Pyron's "Using Microsoft Project" was so full that the VBA chapters were moved to an addendum on the web so it is great to see a book dedicated to just VBA. The book moves from the most basic concepts through creating some useful macros and userforms. It even offers an updated version of something very similar to my "Trace" macro. At the end of each chapter there are some example questions/problems which would make this book very useful if you are teaching VBA in a class. In the US the book was localized by Gary Chefetz and Dale Howard of MSProjectExperts and if you are familiar with their Project Server books you will be happy to see that the same high quality is embodied here. Highly recommended for anyone who wants a solid grounding in Microsoft Project VBA. Here is a link to the book at Amazon.

While you are at it check out Gary and Dale's Project Server Books:

Disclaimer: I know these guys and have had dinner with them at least once.

RELATED POSTS
  • The Best Project Server 2010 Book
  • Microsoft Project 2007 Released
  • Setting Microsoft Project Level Custom fields using VBA
  • VBA returns in Excel 2011 for Mac
  • Books to Consider – Decision Making
  • Iterating through Microsoft Project Subprojects
  • Project Server OLAP Views Errors
  • Microsoft Project Undo Levels and Macros
  • Microsoft Project Server Infrastructure Update
  • VBA and Visual Basic For ... to ... statements

  • Comments (2)

    Greg:

    I need to create a field that shows the date on which a baseline was created. So if I create a new baseline today, the field would return today's date for that baseline and if I update an existing baseline today, the field will return today's date for that baseline. Does this book offer information that will help me do this? And I would love to have any suggestions if you have them.

    ----------------------
    I think that the baseline date is one of those unfortunate properties which can not be read using VBA. At least I have not found a way to do this. Sorry. -Jack

    Greg:

    I need to create a field that shows the date on which a baseline was created. So if I create a new baseline today, the field would return today's date for that baseline and if I update an existing baseline today, the field will return today's date for that baseline. Does this book offer information that will help me do this? And I would love to have any suggestions if you have them.

    Post a comment

    (Comments are moderated to fight SPAM and will be published after I have a chance to approve them. Thanks for waiting.)

    About

    The previous article is Swimming to Cambozola.

    The next article is And now for something completely different.

    Current articles are in the main index page and you can find a complete list of articles in the archives.

    Creative Commons License
    This weblog is licensed under a Creative Commons License.
    Powered by
    Movable Type 3.34