PRJ: Auto_Open and Auto_Close Macros

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. Note that Consolidated MPP is the same as a Master plan; the terminology changed with the release of 2002.

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
Eigenschappen

Artikel-id: 126105 - Laatst bijgewerkt: 29 apr. 2013 - Revisie: 1

Feedback