Custome Enterprise Number fields

[David]

I am attempting to reference and update a custom Enterprise Project Number
field
with VB code. Any help or suggestions would be greatly appreciated.

 

[Ed Morrison]

ActiveProject.ProjectSummaryTask.EnterpriseProjectNumber1 = 1
Debug.Print ActiveProject.ProjectSummaryTask.EnterpriseProjectNumber1

 

[David]

Ed,

Thank you. It appears to work, except when we pull the projects up that
have been saved, all of the EnterpriseProjectNumbers are showing up as 0.
Is there something else I need to do to save the new field value to the
project?

Thanks,
David

 

[Ed Morrison]

Did you publish the project plans? In order for most information to be
available in PWA, the plan must be published.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[David]

Ed,

I didn't describe the problem correctly. I have added code to the
BeforeSave event in the Enterprise Global Template. My goal is to have the
code assign a project number automatically for all of the users when they
save a project. It works fine on my workstation, but the code isn't being
executed on any other workstation when they save a project. I tried placing
the code inside of Project Global (Global.mpt) under Microsoft Project
Objects in the ThisProject (Global.mpt) folder and saved the template, but
that still didn't work. I must be doing something wrong. Any help you can
give would be appreciated....

Thanks,
David

 

[Ed Morrison]

David,
Make sure your code is in the Enterprise Global, not the Global.mpt. The
Enterprise Global (EG) is opened by going to Tools - Enterprise Options -
Open Enterprise Global. The EG is stored in the database and is used by all
Project users when they open up Project Pro. The Global.mpt is stored on
your local machine and is therefore not automatically available to all
users.

Make sure you close then open Project to be assured that you have the latest
version of the EG.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com
FAQ - http://www.projectserverexperts.com

 

[David]

Ed,

I followed your instructions and confirmed that the code is in Enterprise
Global.
The code executes fine on my workstation but will not for my users.

When I open Enterprise Global the code shows up in the areas shown below.

- VBAProject(Checked-out Enterprise Global)
- Microsoft Project Objects
- ThisProject (Checked-out Enterprise Global)
and

- VBAProject(Global(+non-cached Enterprise))
- Microsoft Project Objects
- ThisProject (Global(+non-cached Enterprise))

When the user's open Project Pro the code shows up in one area shown below.

- VBAProject(Global(+non-cached Enterprise))
- Microsoft Project Objects
- ThisProject (Global(+non-cached Enterprise))

I am trying to use the BeforeSave event for projects being saved.

I appreciate your help, thank you...
David

 

[Patrick Summe]

One issue we have with our BeforeSave macro is the Macro security level
on each user's desktop. If an user has security level set to high, the
macro will not run. This may also be an issue for you.

Patrick