How can I get the owner of a project (VBA)

[Dreadou]

Hello,

I'm developping some VBA macro for MS Project. I have to get the owner of a
project. How can I get that with the ActiveProject object ?

I think ActiveProject.Author is not what I want. Sometimes this attribut is
empty and so the author is unknown.

thanks for the reply
Dread

 

[Rod Gill]

Hi,

Try UserName. By default this equals the Author property.

 

[Dreadou]

I got the same problem with UserName. it has an empty string value.

When I'm looking to the projects throw Project Web Access there is an owner
specified for any project. How can I get this value ?

Another question : Is it possible to get the date of the last publication of
a project ?

Dread

 

[Rod Gill]

Don't understand that. If you are logged into Project Server you have to
have a username. Does a username exist for a new project?

 

[Ed Morrison]

You can get the info you need out of the SQL tables. Try the fields WRES_ID
for the owner and wproj_last_pub for the last published date on the
msp_web_projects table.

--
Ed Morrison
msProjectExperts
"We wrote the books on Project Server"
http://www.msprojectexperts.com