File saved by Excel is known as Workbook where each workbook can have one or more worksheets.
Such files can be created by Microsoft Excel as well as other similar spreadsheet programs such as OpenOffice Calc or Apple Numbers.
Files with XLS extension represent Excel Binary File Format. MS Project file only has "resource sheet name" data.Īny ideas what is happening. ' force an error condition if key does not existĬC: Excel file and MS Project file. If VarType(pColl.Item(pKey)) = vbObject Then Public Function ExistsInCollection(pColl, ByVal pKey As String) As Boolean Newproj.Tasks(i - 1).ResourceNames = Strresource StrWork = Worksheets("LABOR_IMS_INPUT").Range("G" & i) Strresource = Worksheets("LABOR_IMS_INPUT").Range("F" & i) StrDuration = Worksheets("LABOR_IMS_INPUT").Range("E" & i) StrEndDate = Worksheets("LABOR_IMS_INPUT").Range("D" & i) StrStartDate = Worksheets("LABOR_IMS_INPUT").Range("C" & i) 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)
