Install VBA Code

[Chris]

This seems like it should be simple but I haven't been
able to find any documentation on it.

I have developed VBA code and I want to create a way for
people to install the code easily on their computer.
Does anyone have any idea how to write to the GLOBAL.MPT
file without invoking Project?

Thanks for any help.

 

[Chris]

There are a couple things with this that pose an issue.
FIrst the ThisProject.cls does not seem to be overwritten
with the OrganizerMoveItem command. I might be able to
get by if I had to if this worked. But the people that
are using these macros are very unskilled Project users
and having them open up VBA in order to run a routine is
something I would rather not have them do.

Right now my default seems to be to just replace the
users GLOBAL.MPT file since this solves the
ThisProject.cls issue and doesn't involve invoking
Project.

But I would rather just write to the GLOBAL.MPT instead
of replacing it.

Thanks,
Chris

 

[Jan De Messemaeker]

Hi Chris,

Se my comments embedded

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

There are a couple things with this that pose an issue.
FIrst the ThisProject.cls does not seem to be overwritten
with the OrganizerMoveItem command. I might be able to
get by if I had to if this worked. But the people that
are using these macros are very unskilled Project users
and having them open up VBA in order to run a routine is
something I would rather not have them do.

Exactly; what I mean is to have a Project_open event driven macro in
ThisProject
THAT DOES ALL THE COPYING FOR THE USERS.
They will not even be aware of it.
I have done this for several customers, for hunreds of PLs.

Right now my default seems to be to just replace the
users GLOBAL.MPT file since this solves the
ThisProject.cls issue and doesn't involve invoking
Project.

What on earth is ThisProject.cls?
In the VBA ProjectExplorer, Click on ThisProject, you will be shown a Module
you can write the Project_Open Macro in it.

I can send an example if you do not know how.

But I would rather just write to the GLOBAL.MPT instead
of replacing it.

This is indeed what I recommend.
OrganizerMoveItem is THE method that wites object to the Global.mpt