Project properties

[meg99]

using 2003. I want to dynamically define the project property fields
using VBA - not a file name but a title. When I select File,
Properties a dialog shows that Title, Subject, Author etc under the
summary tab. I would like to use VBA to code those. Is there a way
to do that?

meg99

 

[John]

using 2003. I want to dynamically define the project property fields
using VBA - not a file name but a title. When I select File,
Properties a dialog shows that Title, Subject, Author etc under the
summary tab. I would like to use VBA to code those. Is there a way
to do that?

meg99

meg99,
You can. I'd first go to the VBA object browser and get the help file on
the DocumentProperty Object. That will give a list of all the built in
document properties (i.e. Title, Subject, Author, etc.). These are
indexed as 1, 2, 3, etc. So for example, to set the Title property of
the active file, use the following:
ActiveProject.BuiltinDocumentProperties(1)="meg99"

Hope this helps.

John
Project MVP

 

[meg99]

Thanks John,
It never occured to me to look under DocumentProperties since almost
everything else is Activeproject. something.

Thanks again

meg99

 

[John]

Thanks John,
It never occured to me to look under DocumentProperties since almost
everything else is Activeproject. something.

Thanks again

meg99

meg99,
You're welcome and thanks for the feedback.

John

 

[Jan De Messemaeker]

Hi,

Activeproject.builtindocumentproperties("Title") works just as well
No need to look for the index.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf