Creating Macros on EGlobal

J

Jennifer L

Is creating new macros directly on the Eglobal considered polluting the
Eglobal? Is this a best practice? Would it be better if I created the macro
on a new project file then used the organizer to copy it to the Eglobal?

What are the pros and cons of creating macros directly on the Eglobal?
I have many books on MS Project Server that deomonstrate the way to create a
new macro (or other object - like a table or view) is directly on the
Eglobal, but reading through posts on this site I'm getting conflicting
advice. Please clarify.

Thank you!
Jennifer
 
J

Jack Dahlgren MVP

As long as the macro is not trash, it is not polluting.
However, macros are rarely perfect the first time and often require several
iterations.
When they are in the eglobal, each of those changes requires you to save and
checkin the global. After that you have to shut down project and restart it
to have your changes take effect.
Users who are using the eglobal get a message that it has changed.
Eglobals can get corrupted. This happens when they are opened and not
checked back in correctly.
Backing up and versioning of the eglobal is not as easy now as it was in
2003.

Therefore:
Minimize the time the eglobal is open by developing with a macro within a
file then port it over at one time.
Minimize your waiting time by developing within a file.
Minimize the number of messages your users get by developing within a file
Implement a backup and versioning system easily by developing within a file
and saving off different versions as you go along.

If I'm just fixing a known bug (typo etc.) on a macro already in the global,
I may do that on the fly. But it is not the best practice if you are
developing anything complex.

-Jack Dahlgren
 
R

Rod Gill

Seconded! Only edit the Eglobal if absolutely necessary, especially with SP2
installed and always remember to save immediately on open! Corruption of
Eglobal if it's closed without saving is still common.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
J

Jennifer L

Thank you both for the clarification. This was very helpful to me!
-Jennifer
 
Top