DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 126105 - Last Review: April 29, 2013 - Revision: 6.0

This article was previously published under Q126105

On This Page

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

Applies to
  • Microsoft Project 98 Standard Edition
  • Microsoft Project 4.1 Standard Edition
  • Microsoft Project 4.0 Standard Edition
  • Microsoft Office Project Professional 2007
  • Microsoft Office Project Professional 2003
  • Microsoft Office Project Server 2007
  • Microsoft Office Project Server 2003
  • Microsoft Office Project Standard 2007
  • Microsoft Office Project Standard 2003
  • Microsoft Project 2000 Standard Edition
  • Microsoft Project 2002 Standard Edition
  • Microsoft Project 2002 Professional Edition
  • Microsoft Project Professional 2010
  • Microsoft Project Standard 2010
  • Microsoft Project 2013 Professional
  • Microsoft Project 2013 Standard
Keywords: 
kbcode kbinfo kbprogramming KB126105
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support