How to update Status Manager for each task using VBA ?

[Smugliy]

Is there any way to update status manager field for any task using VBA ?

Because I can only update it to the current user.When I am trying to update
for somebody else I am receiving an error.
As I can see from SDK there is no way to update it with PSI ,right ?

example of code in C#:
string current_manager =
applicationObject.ActiveProject.ProjectSummaryTask.StatusManagerName;
foreach (MSProject.Task task in
applicationObject.ActiveProject.Tasks)
{
if (task != null)
{
if (task.StatusManagerName != current_manager)
{
task.StatusManagerName = current_manager;
task.StatusManagerName = "test" //DOESN'T WORK
!!!!
}
}

}

 

[Rod Gill]

The Status Manager has to be a valid Resource for the Project, so unless you
have an Enterprise resource called Test, I would expect that to fail.

--

Rod Gill
Microsoft MVP for Project

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

 

[Smugliy]

There is no matter if I am putting correct enterprise resource or something
else .

I am always receiving exception

 

[Jayesh Patel]

I am not able to see Status Manager list. It alway give me one person. Also I would like assign separate Status Manager for each of the task. What is best approach?

 

[Stephen Sanderlin]

The Status Manager field can only be set to either yourself or an
existing Status Manager. This means that you will have to have each PM
open the project themselves and set themselves to status manager on the
appropriate tasks.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com