![]() ![]() If so, moving it to arrays of custom types is adding unnecessary complexity. If you are working from Excel, likely your data is in a worksheet. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |