Knowledge Base

PRJ: Auto_Open and Auto_Close Macros

Article ID: 126105

Article Last Modified on 1/19/2007

APPLIES TO

This article was previously published under Q126105

SUMMARY

In Microsoft Project, when you use the Auto_Open or Auto_Close Visual Basic, Applications Edition, macro names, the macro will run either when a file is opened or when it is closed, respectively.

This behaviour does not work for embedded projects, or project files linked into other applications. Auto_Open/Auto_Close will not function in these cases

MORE INFORMATION

The following table shows the behavior of an Auto_Open or Auto_Close macro depending on whether the macro is located in a Microsoft Project MPP/MPT file or in GLOBAL.MPT. Also noted is behavior relating to consolidated project files and Microsoft Project version 3.0 MPV and MPC files.

Auto_Open Macro

   Type of File Opening    Macro Location            Auto Macro Runs From
   ----------------------------------------------------------------------
   Normal MPP/MPT          GLOBAL.MPT                GLOBAL.MPT
   Normal MPP/MPT          MPP or MPT                MPP/MPT
   Normal MPP/MPT          GLOBAL.MPT and MPP/MPT    MPP/MPT
   Foreign (MPX, CSV,      GLOBAL.MPT                GLOBAL.MPT
   and so on)
   3.0 MPV or MPC          GLOBAL.MPT                Does Not Run
   Consolidated MPP        GLOBAL.MPT                Does Not Run
   Consolidated MPP        MPP                       Does Not Run
   Consolidated MPP        GLOBAL.MPT & MPP          Neither Macro Runs

Auto_Close Macro

   Type of File Closing    Macro Location            Auto Macro Runs From
   ----------------------------------------------------------------------
   Normal MPP/MPT          GLOBAL.MPT                GLOBAL.MPT
   Normal MPP/MPT          MPP or MPT                MPP/MPT
   Normal MPP/MPT          GLOBAL.MPT and MPP/MPT    MPP/MPT
   Foreign (MPX, CSV,      GLOBAL.MPT                GLOBAL.MPT
   and so on)
   3.0 MPV or MPC          GLOBAL.MPT                GLOBAL.MPT
   Consolidated MPP        GLOBAL.MPT                GLOBAL.MPT
   Consolidated MPP        MPP                       MPP
   Consolidated MPP        GLOBAL.MPT & MPP          MPP
NOTE: A major difference regarding consolidated project files and version 3.0 MPV and MPC files is that when you open these files, Auto_Open macros do not run; however, when you close them, an Auto_Close macro WILL be run if one exists.

In addition, if an Auto macro exists within an MPP or MPT file, the macros will not be run when you open or close a different file.

REFERENCES

For more information about Creating A Sub Procedure That Runs Automatically, choose Contents from the Help menu, choose Visual Basic Reference, choose the Search button, and type:

Creating

Keywords: kbcode kbinfo kbprogramming KB126105


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.