VBA Object Model Changes

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

The Microsoft Office Project 2007 desktop client applications—Project Standard 2007 and Project Professional 2007—include an upgrade of the Microsoft Visual Basic for Applications (VBA) object model. The Project 2007 object model includes bug fixes from earlier versions and support for new features in the Project 2007 platform.

The VBA object model in Project Standard 2007 includes support for the following new features:

• Simplified custom fields and outline codes

• Multiple undo and redo actions

• Effective calendar dates and calendar exceptions

• Advanced desktop reporting using Visual Reports

• Task drivers and recalculation change highlighting to help clarify scheduling processes

• Costs and budget

The Project Professional 2007 object model includes the Project Standard features and adds support for the following:

• Project Deliverables for improved collaboration and cross-project links

• Conversion or mapping of local custom fields, calendars, and resources to enterprise

• Validation of enterprise formulas

• Queuing Service events

• Importing of a Windows SharePoint Services 3.0 project

• Saving of a local copy of a Project Server project for sharing

In total, the Project 2007 object model includes 1424 new, changed, or hidden items, as follows:

• New classes: 13

• Class members added, changed, or hidden: 1067

  Properties: 949
  Methods: 110
  Events: 8

• New enumerations: 24

  New enumeration members: 322

Enterprise custom field properties All of the enterprise custom field and enterprise outline code properties are hidden because Project Server 2007 is not limited to built-in enterprise custom fields. For more information about enterprise custom fields and outline codes, see Local and Enterprise Custom Fields.

Creating a custom toolbar in the enterprise global To deploy a macro to a group of Project Professional users, you can copy the macro to the enterprise global template. You can then create a custom toolbar, copy that to the enterprise global, and reference any required files in the macro by using a SharePoint site. For more information and an example, see Changes for Custom Project Guides.

Using VBA Help The Project 2007 SDK does not include the full VBA Help reference. To access VBA Help, open the Visual Basic Editor in Project, and then click the Help menu or press F1. The VBA Help file for Project 2007 is the Microsoft Help 2.0 format WINPROJDEV.HXS file in the [Program Files]\Microsoft Office\Office12\[LCID] directory, where LCID is the locale ID. For example, the English VBA Help for Project is [Program Files]\Microsoft Office\Office12\1033\WINPROJDEV.HXS. To access updated VBA Help, click the Connection Status menu in the lower right corner of the Project Help window, and then select Show content from Office Online.

The developer technologies and tools for automating Project 2007 include the Visual Basic Editor (VBE) for recording and developing VBA macros and integrating with Microsoft Office Word, Microsoft Office Excel, and the hundreds of other applications that expose a VBA object model. The primary interop assembly for Project 2007 helps developers take advantage of the power and features of the Microsoft .NET Framework and integrate with the Project object model from managed assemblies.

Note

Methods that have changed parameters have Ex (for Extended) appended to the method name. When you record a macro in Project 2007, the macro uses the changed methods. For example, when you are recording a macro and close the project file, the macro records FileCloseEx. The original methods are hidden in the Object Browser in the VBE. To see hidden members, right-click anywhere in the Object Browser window and then click Show Hidden Members. Hidden members are not documented in the Project 2007 VBA Help file or in the Project 2007 SDK.

VBA remains useful for recording macros and developing relatively simple Automation solutions. The .NET Framework 3.0, Microsoft Visual Studio 2005 Tools for the Microsoft Office System - Second Edition (VSTO 2005 SE), and the Project 2007 primary interop assembly provide advantages for developing more complex, secure, and scalable solutions that automate the Project 2007 desktop clients. The next release of VSTO with Visual Studio 2008 includes templates for developing application-level add-ins for Project 2003 and Project 2007 (either the Project Standard or Project Professional versions). VSTO 2008 greatly simplifies developing, testing, and deploying advanced integration solutions that use the Project desktop client.

In This Section

Using the Project.Open Event

Shows how to use different Project_Open event handlers in the global template, enterprise global template, and local projects.

• How to: Create and Use a Transaction Set for Multiple Undo/Redo Actions
  Describes several new properties, methods, and an event that support multiple-level undo and redo functionality.

• Using VBA with Local Custom Fields and Outline Codes
  Describes how Project 2007 simplifies the administration of custom fields and outline codes. Shows how to use VBA to create local custom fields.

• Visual Reports
  Explains how Project 2007 supplements the reporting features available in Project 2003 with advanced desktop reporting called Visual Reports.

• Calendar Exceptions and Effective Work Weeks
  Discusses the concept of effective dates in Project 2007, where all calendar data is associated with a set of "valid from/to" dates, and how you can add exception sub-calendars.

• Project Deliverables
  Describes the Deliverables feature in Project 2007, a simpler and much improved way to manage dependencies between projects and cross-project links.

Reference

• Tables of VBA Object Model Changes
  Tables of types and the new or changed objects, properties, methods, events, and enumerations that help you develop or adapt Automation solutions using the Project 2007 object model.

Related Sections

• Project Server Architecture and Programmability
  Includes an overview of Project Web Access servers, the Project Server Interface (PSI), Project Server business objects, and the data access layer (DAL).

• Working with the PSI and DataSets
  Provides an introduction to development using the PSI, including sample code for working with the Microsoft ADO.NET 2.0 DataSet types that the PSI uses.

• PDS Parity in PSI Web Services
  Explains the functional parity of the managed code PSI with the XML-based Project Data Service (PDS) in Project Server 2003.

• PSI Reference Overview
  Describes the namespaces in the PSI Web services and the related Project Server assemblies.

See Also

Concepts

Changes for Custom Project Guides

Other Resources

Microsoft Office Developer Center

Project 2003 Object Model and VBA Reference

VBA Language References

Visual Studio Developer Center