![]() I was hoping it'd be something along the lines of .ĭerrick, you need to export timescaled data (i.e. ![]() XlRange.Range("A1:C1").EntireColumn.AutoFitĪctiveWindow.Caption = ActiveProject.Name 'check current loop date is not greater than end date Range("A1") = Format(tsk.Start, "short Date") & vbCr & "Install Excel or check network connection", vbCritical, _ĪctiveWindow.Caption = " Writing data to worksheet" MsgBox "Excel application is not available on this workstation" _ Set xl = CreateObject("Excel.Application") TotalDates = DateDiff("d", prjStart, prjFinish) ' create an array of dates to iterate through ' assigning the project start date for loop var prjDate ![]() Option Explicitĭim prjStart As Date, prjFinish As Date, prjDate As Date, dateLoop As Date, dateArray() As Date ![]() It is showing the amount of work hours for the task. I am struggling with showing the number of hours worked per day. I'm trying to create an Excel spreadsheet from MS Project that will iterate through the project start to finish dates, & for each date (in ascending sequence from the start) output the amount of work hours each resource is assigned for each task that is scheduled to take place on that day. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |