Free Book Online
Book VBA Programming for Microsoft Project '98 Through 2010 with an Introduction to VSTO


VBA Programming for Microsoft Project '98 Through 2010 with an Introduction to VSTO

2.4 (2187)

Log in to rate this item

    Available in PDF - DJVU Format | VBA Programming for Microsoft Project '98 Through 2010 with an Introduction to VSTO.pdf | Language: ENGLISH
    Rod Gill(Author)

    Book details

This book teaches you to develop VBA macros for Microsoft Project that are productive, quick to develop, and easy to maintain. The learning examples included in this book give you a great jumpstart for your own Project VBA programming projects. I document an array of useful macros, including routines for viewing all tasks linked to the selected one, automatically creating a consolidated snapshot of multiple project files, a Who Does What When report exported to Excel, and more. In this book, I teach you how to write VBA macros for Microsoft Project by explaining how to design them for easier code maintenance.

For those of you new to VBA programming, Section 1 explains the part of Project VBA that is common to VBA for all Microsoft Office applications. Section 2 is specific to Project VBA and covers the full range of skills you need to automate Microsoft Project. Section 3 documents how to read and write data to Project databases and how to report on projects in a Project Server database.

3.3 (12166)
  • Pdf

*An electronic version of a printed book that can be read on a computer or handheld device designed specifically for this purpose.

Formats for this Ebook

Required Software Any PDF Reader, Apple Preview
Supported Devices Windows PC/PocketPC, Mac OS, Linux OS, Apple iPhone/iPod Touch.
# of Devices Unlimited
Flowing Text / Pages Pages
Printable? Yes

Book details

  • PDF | 365 pages
  • Rod Gill(Author)
  • msProjectExperts (1 Mar. 2011)
  • English
  • 2
  • Computing & Internet

Read online or download a free book: VBA Programming for Microsoft Project '98 Through 2010 with an Introduction to VSTO


Review Text

  • By Exclarsach on 28 February 2012

    I'm an experienced user of MS Project 2002 through 2010, but haven't needed to do much VBA coding so far. I wanted to understand how VBA holds together, and how to write efficient code (I was a proper programmer a long time ago, so this is important to me!). This book's narrative is easy enough to follow - not too "American" if you know what I mean - and well paced for working through. It does, however, highlight (to me at least) that VBA is a bit of a mish-mash, with certain types of code having to be stored in different locations from others, and with a lack of syntactical consistency. This obviously isn't the book's fault!There are sample .mpp file downloads provided via weblinks, which saved a lot of typing - the book also shows all the code anyway (and some of the downloads differed from the book...). I did, however, struggle with several of the worked examples / exercises as some just didn't work with Project 2010 as written. One or two of these took quite a while to fix, which slowed the whole process down somewhat.However, there are many very useful examples in the book, some of which are immediately useable as they are, and some which provide a good basis for further development to suit the specific requirements of different jobs. All in all, a very worthwhile buy for anyone who needs to get more out of MS Project, especially for automated reporting.

  • By Patrizia Monti on 28 November 2006

    This is the first book I know entirely dedicated to VBA for Project. It is useful for beginner as well as advanced developers.Rod made a great job: many notes, many examples and exercises for each module.Compliments!I highly recommend this book.

  • By Artemis on 13 December 2016

    As far as I know, there are only two books on this topic. This one, and its previous edition. I could perhaps write a third book, but don't have Mr Gill's patience with readers new to programming.In my view, at best, he covers about 30-50% of the Ms Project VBA world. My version would cover almost completely different stuff, like how to fire-off emails from a project file automatically, how to svae change notices on file saves, how to do extensive QA checks on file open.It may look expensive, but if you are a contract planner, and wish to learn VBA, this will have paid for itself by the second coffee of the morning.If you are a serious planner, you should learn VBA and how to use it. It will give you a significant edge.It's a black art. Very little Microsoft documentation on this. You have the object models, and have to basically work things out from that.All hail Mr Gill, but as I say, he's only scratching the surface here. A very valuable scratch, and well worth the money if you are a professional.

  • By amr saeed mustafa abdeen on 14 December 2012

    i have been looking for courses on programming microsoft project 2010.this book is exceeding my expectations and help me in my career.

  • By JotaGue on 30 April 2012

    Thanks to the author of this book. It's very helpful. With it we can have a great performance on de deploiment on project management.

  • Name:
    The message text*: