Microsoft Project Vba
Good afternoon, I'm very new to VBA and I've had some little successes which have very much spurred me on to keep learning! Unfortunately, I've come a little un-stuck trying to loop through tasks in Microsoft Project. Having sub-projects completely changes the game. In a master linked project, the only tasks are the sub-project tasks. To see the tasks in sub-projects, you need to expand them, or use the subproject object and loop thru all tasks in the sub project. In addition you need a: If not t is Nothing Then End if In case there are any blank rows in your project. Finally be very, very careful with linked master projects.
NEVER rename, move, over-write or store on disk drive not in your building. If you do you will role the file corruption dice. Its when, not if.
Microsoft Project Vba Reference
VBA help for Microsoft Project. If this is your first visit, be sure to check out the FAQ by clicking the link above. I use MS Project Professional 2013, and I need to find a tool for code management for VBA. I would like this tool to be able to import and export code from/to MSP and.
Much better is to have a macro create an unlinked master each week for reporting to avoid any chance of file corruption. Having sub-projects completely changes the game. In a master linked project, the only tasks are the sub-project tasks. To see the tasks in sub-projects, you need to expand them, or use the subproject object and loop thru all tasks in the sub project. In addition you need a: If not t is Nothing Then End if In case there are any blank rows in your project. Finally be very, very careful with linked master projects. NEVER rename, move, over-write or store on disk drive not in your building.
If you do you will role the file corruption dice. Its when, not if. Much better is to have a macro create an unlinked master each week for reporting to avoid any chance of file corruption. Rod, Thanks for your response, I'll try this now, and thanks for the advice about creating a new version before running the macro, I'm doing that manually at the moment. Can I ask you to explain this a little for me? For Each t In ActiveProject.Tasks If Not t Is Nothing Then If t.Subproject ' Then SubProjId = t.ID ElseIf Not t.Summary Then SelectRow Row:=SubProjId + t.ID, rowrelative:=False So here I'm reading that if the Task is something then do 'SubProjId = t.ID But, if the task is nothing then; if the task is not a summary do 'SelectRow etc.'
Microsoft Project Vba Objects
Doesn't this mean that the macro will never run the summary check? I think i'm missing something pretty big here, I'm sorry to say.