StrTaskName = Worksheets("LABOR_IMS_INPUT").Range("B" & i) StrWBS = Worksheets("LABOR_IMS_INPUT").Range("A" & i) Set pjapp = CreateObject("MSProject.Application") Here is the VBA I have now: Sub ExceltoProject()ĭim strValue, strStartDate, strEndDate, Strresource As String I really appreciate any help anyone can give me! If there are questions, I'm happy to answer them. I've tried copy and paste, but there has got to be a better option with VBA (I hope?)
Here is a screenshot of what I am looking for a VBA code to be able to produce from Excel to MS Project:ĬC: MS Project file showing columns of WBS, Task Name, Start Date, Finish Date, Duration, Work, and Resource Name with resource names grouped by WBS. Here is a screenshot of what I have in Excel:ĬC: Excel table of column headers of: WBS, Task Name, Start Date, Finish Date, Duration, Work, and Resource Name with rows of data that are independent of resource name assignment. I'm trying to take a table of data from Excel and import it into MS Project
0 kommentar(er)
