Event handler and project server

[SharkTracker]

I have a standalone project that runs events without any problems. Here is
the problem, I moved it to project server and now the event handler does not
activate when the project schedule is opened. If I manually run the event
handle things work fine.

Any suggestions?

 

[Rod Gill]

So the code is in a Project 2007 file? Or in the Global.mpt file on your PC?
Or the Enterprise Global?

Which Event?

--

Rod Gill
Microsoft MVP for Project

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

 

[SharkTracker]

Global.mpt
--
Sharktracker

So the code is in a Project 2007 file? Or in the Global.mpt file on your PC?
Or the Enterprise Global?

Which Event?

--

Rod Gill
Microsoft MVP for Project

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

 

[Rod Gill]

Which event?

Project and project server 2007?

--

Rod Gill
Microsoft MVP for Project

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

 

[SharkTracker]

I am using Project Pro 2007 and Project server 2007. I also tried placing the
event code in the Global+enterprise and still got the same result. I was
going to place the event code in the local project schedule; however; once
you pulblish the vba code window only shows the global.mpt and
Global+enterprise. What happens to the local settings?

 

[Rod Gill]

What do you mean by local settings? Code in .mpp and global.mpt files should
continue working as usual.

What event?

Which bits of the code do and don't work?

--

Rod Gill
Microsoft MVP for Project

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

I am using Project Pro 2007 and Project server 2007. I also tried placing
the
event code in the Global+enterprise and still got the same result. I was
going to place the event code in the local project schedule; however; once
you pulblish the vba code window only shows the global.mpt and
Global+enterprise. What happens to the local settings?

 

[SharkTracker]

Ok I am back. Here is the deal.

I have a project schedule that uses events. They are setup up as you outline
in your book. They also work just fine. The problem is when I open project
pro and connect to server they do not work. The "Project_Open routine does
not execute; hench, the events do not get activated.

The class and modules are contained in the Global.MPT

My question is why does it not work when connecting to project server when
opening as a standalone schedule it does?

 

[Rod Gill]

Does the Project_Open event not run at all? Try a Stop command in it or a
Msgbox. I don't understand why it wouldn't. Do you have at least SP1
installed in Server and Project Pro?

--

Rod Gill
Microsoft MVP for Project

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

 

[SharkTracker]

I have a message box in the code as well as a debug.print.. I have all of the
latest patches. If I manually run the handeler code it then run just fine. I
can close one project and open another it works like it should. I just cannot
get it to start automatically the first time.

 

[Rod Gill]

Is this problem just on your PC or is it the same on another one? I don't
know what's happening, so I'm into "what isn't it?" mode. If it works on
another PC then maybe it's your profile or PC. If it doesn't work on another
PC maybe a recent update broke something.

--

Rod Gill
Microsoft MVP for Project

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

 

[SharkTracker]

Are there any project server settings that would cause this?

 

[Rod Gill]

I don't think there are any settings in Project Server that affect VBA.
However, if you have code in the Global Enterprise file it may conflict with
the local code, but I'm not sure what code might do this.

--

Rod Gill
Microsoft MVP for Project

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