Trying to add 'open to current day' logic to Global.mpt ...

J

jlg

I am an administrator for PS 2003 and have been trying to get 'open to
current day by default' working in Global.mpt.

The very basic code is as follows:

Private Sub Project_Open(ByVal pj As Project)
EditGoTo Date:=Now()
End Sub

1st, I tried to add it to my Global.MPT; I have those 3 basic lines +
a msg line stating 'this is from global mpt'. So then I exited
Project and went back in - I did not receive any msg and it does not
jump to the appropriate current date (I tried opening many plans).

....i.e., I could not get it working.


2ndly, I added the code to a specific Project that I had opened; I
have those 3 basic lines + a msg line stating 'this is from xxx
Project'. So then I exited Project and went back in to the project I
added this code to - I did successfully receive the msg and it does
jump to the appropriate current date.

3rdly, I added it to Enterprise Global; again, I have those 3 basic
lines + a msg line stating 'this is from GET.' So then I exited
Project and went back in - I did receive both messages - the one from
the individual project and the one from GET and it does jump to the
appropriate current date. This occurs for every plan i open.


I go into my Tool / Macros / Visual Basic Editor and look at
ThisProject (Global.MPT)
This Project (Global(+cached Enterprise)).

I see both sets of code + the accurate msg in both.

I just cannot figure out why I cannot get it working in the
Global.MPT. any insights??? The reason why we want it in
Global.MPT is then each PM can decide whether they want this code on
their machine or not....

all insights are greatly appreciated! tx...jlg
 
J

Jonathan Sofer

I believe the global.mpt file gets overridden with the enterprise global
each time you connect to the server.

Have you tried the global.mpt approach working completely offline to see it
that works?

Jonathan
 
J

jlg

I believe theglobal.mptfile gets overridden with the enterprise global
each time you connect to the server.

Have you tried theglobal.mptapproach working completely offline to see it
that works?

Jonathan
















- Show quoted text -

Jonathan,

Thanks for your idea. I am now beginning to think this is an issue
with Global.mpt here, caching or the fact that our Project Server
version is on Service Pack 1, yet our Microsoft Project clients are on
SP2. Here is what I have done:

Opened Plan X
Saved Plan X Offline
Exited MS Project
Opened MS Project, working Offline
Opened Plan X
Message showed from the Enterprise Global; unique message from
Global.mpt did NOT show.
Exited MS Project.
Opened MS Project, working ONline.
Opened Plan X. Saved plan ONline
Opened Enterprise Global. Erased code in Enterprise Global. Saved
Enterprise Global.
Confirmed Global.mpt still had the code.
Saved Plan X.
Then Saved Plan X again OFFline
Opened MS Project, working OFFline.
Opened Plan X.
No messages.

I then decided I needed to have others try doing this. I had another
administrator and 2 other people try adding this code to their
Global.mpt. All received the same message after pasting into the
macros ThisProject under Global.mpt:
'Error accessing file. Network Connections may have been lost.'
Person saves global.mpt.
Then exits the Visual Basic editor.
And receives this message:
'You have modified a signed project. You do not have the correct key
to sign this project. The signature will be discarded.'
And one final message when closing the project plan:
'There was a problem with the digital certificate. The VBA project
could not be signed. The signature will be discarded.'

Help?! Now where to go?


all help is VERY much appreciated!!! ...jlg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top