![]() StrMilestone = Worksheets("Milestones").Range("C" & M) ![]() 'here I would like to insert milestones as subtasksįor M = 3 to 5 ' this I also would like to be a named range and also I need to check for or lookup the correct main task and the corresponding milestone list Newproj.Tasks(I - 2).Predecessors = (I - 3) StrValue = Worksheets("Planning").Range("A" & I) Set pjapp = CreateObject("MSProject.application")įor I = 3 To 8 'currently I am pointing to the range A3:A:8 - would like to make it a named range instead - ie "Maintasks" - how to do this? Sub MSPexport()ĭim strValue, strWorktime, strMilestone As String Each main task has a corresponding table of milestones. ![]() I would like to insert milestones under each main task from a specific table in excel. I am now looking for help making it a bit more useful. I managed to make a nice script that can generate a MS-project file from selected tables in excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |