The summary task will be from the resourceSummary custom datatype and will use beginningDate As Date My Problem Above however is that I still need to create summary tasks to put all those subtasks inside. Pj.Tasks(z).Finish = groupsArray(i).taskList(j).dateEnd Pj.Tasks(z).Start = groupsArray(i).taskList(j).date TempName = groupsArray(i).taskList(j).taskName z = 1įor i = LBound(groupsArray) To UBound(groupsArray) The array is already filled with data now I just need to output into project. GroupsArray is indexed from 0 to 7, meaning that there are 8 summary tasks needed to be made with as many subtasks inside them. I've declared these two variables, Dim timelineArray() As TimelineInfo The resourceSummary would be the Summary Task, with all tasks in taskList() going underneath that respective resource summary name. Many thanks, My custom structs: Type TimelineInfo How would I go about now given that I have all the necessary info (name/summary name/start & end dates) and be able to in VBA automatically loop through and put this into MS Project? All subtasks in TaskList for that respective array index belong to the same Summary name and would be in this format: This array called TaskList() would then hold as many subtasks inside as the number of tasks.
Summary Name (The subtask would go under their respective summary.My array consists of a custom datatype as following: I created an array of my own custom type which read in this data but now I need to output my array onto Project. So I have a Timeline in Microsoft Excel which contains a variety of information.
0 kommentar(er)
