Vba Programming For Microsoft Project 98 Through 2010 With An Introduction To Vsto _top_

Project 98 was a landmark release for developers. It introduced the VBA IDE (Integrated Development Environment) as we know it today. Prior to this, customization was limited to macros that were often difficult to edit. In Project 98 and 2000, the object model was relatively simple. The focus was on the ActiveProject object. Code written in this era often relied on direct selection methods (e.g., SelectRow ), which were prone to errors if the user interface state changed.

Dim pjApp As MSProject.Application Set pjApp = GetObject(, "MSProject.Application") However, for code running inside the Project file, you typically work directly with ActiveProject . This object represents the currently open schedule. The Task object is where the magic happens. In Project 98, iterating through tasks could be slow if done inefficiently. By Project 2010, processors were faster, but best practices remained the same: avoid Select statements. Project 98 was a landmark release for developers

Project 2010 brought the Ribbon UI, representing the biggest paradigm shift since the introduction of VBA. While the VBA language itself didn't change drastically, the user interaction did. The CommandBars object—once the staple for creating custom menus—was effectively deprecated. Developers now had to customize the Ribbon using XML, a process that was notoriously difficult to do purely within VBA. However, the core object model for tasks and resources remained backward compatible, ensuring that a well-written macro from 1998 could still run in 2010. Core Concepts: Writing Robust VBA Code When programming for the 98–2010 spectrum, "robustness" is the keyword. Code that relies on user interface selection is fragile. The mark of a professional VBA developer is the ability to write code that interacts with data objects, not the screen. 1. The Application and Project Objects Every journey begins with Application . This is the top-level object representing Microsoft Project itself. In Project 98 and 2000, the object model