none
change Status manager Macro RRS feed

  • Question

  •    
    Following macro to change the status manager is not working :(
    Dim T As Task
        For Each T In ActiveProject.tasks
            If Not (T Is Nothing) Then
                    T.StatusManagerName = "TestName"
            End If
        Next T

    Thanks, Parth
    Tuesday, May 3, 2011 7:33 AM

All replies

  • Hi Parth,

    Wha exactlyt is not working? Any error messages?

    Keep in mind that you cannot set the Status Manager to any person you like. The Status Managers can only be set to yourself (the person who has opened the Project) or to a user that is already the Status Manager on another task.

    I hope this helps,
    Hans


    My EPM blog: Projectopolis
    Tuesday, May 3, 2011 8:04 AM
    Moderator
  • My requirement is to change the status manager for each assignment?????

     

    is there any other way to update the status manager from database directly or using PSI ??

     


    Thanks, Parth
    Tuesday, May 3, 2011 9:47 AM
  • Hi Parth,

    As Hans Said:
    The Status Managers can only be set to yourself (the person who has opened the Project) or to a user that is already the Status Manager on another task.

    A user can not directly assign other user if above condition does not match

    So don't know whether it is possible through PSI or not, but if it is posiible to change the status manager through PSI. Then you can use impersonation to achieve the same.

    You just impersonate yourself with that user then after impersonation then make that user as status manager for particular task.

    Same way you can change the status manager for other task also.

    But before that check whether it is possible through PSI or not.

    Hope this may help you.


    Sachin Vashishth MCTS
    Tuesday, May 3, 2011 1:01 PM