Read current settings using VBA

[Guidho]

I need to check current settings and selected options using VBA.
However, I can't find some options/settings in the MS Project VBA object
model.

Collaboration Options
- "Publish New and Changed Assignments" updates resources' assignments when
- On every save, publish the following information to Project Server: New
and Changed Assignments (I can read Project summary, but not this option)

Save Options:
- AutoSave, Interval, ...
As far as I know, this is not possible

Published fields (Tools -> customize -> Published fields)
- everything about custom fields (what fields, task or assignment, let
resource change value, ...)

If you know how to read (not write, I know how to do that) all or some of
these options please let me know! Or if you know it is imposible, also let me
know.

Thank you!

 

[John]

I need to check current settings and selected options using VBA.
However, I can't find some options/settings in the MS Project VBA object
model.

Collaboration Options
- "Publish New and Changed Assignments" updates resources' assignments when
- On every save, publish the following information to Project Server: New
and Changed Assignments (I can read Project summary, but not this option)

Save Options:
- AutoSave, Interval, ...
As far as I know, this is not possible

Published fields (Tools -> customize -> Published fields)
- everything about custom fields (what fields, task or assignment, let
resource change value, ...)

If you know how to read (not write, I know how to do that) all or some of
these options please let me know! Or if you know it is imposible, also let me
know.

Thank you!

Guidho,
Unfortunately there are many properties in Project that simply are not
available through the Project object model. I don't know about the exact
items you mention but without digging into the Project object browser
(which it looks like you've already tried), my guess is those properties
are not accessible through VBA. It is similar to text font
characteristics. Many users have asked if it is possible to tell the
color of a font using VBA in Project. The only way to do that is
indirectly. In other words, you need to know what criteria was used to
set the font characteristics in the first place and then test for that
criteria.

John
Project MVP

 

[Guidho]

Thank you John,

That was what I was affraid of. I know there are some 'hidden' properties
which are not in the object model. That why I was asking...

Oh well, I'll try to figure out a workaround. Thanks again.