![]() ![]() ![]() Regardless, I kept getting a run-time error of 1101 with no success. I tried testing this script on one day worth of data to cut down on processing time. One more thing, you can set the fiscal year start month in the File->Options->. Set TSVSBaselineCost = t.TimeScaleData((ActiveProject.StatusDate), ActiveProject.StatusDate, pjTaskTimescaledBaseline9Cost, pjTimescaleMonths, 1)įor Each TSVBaselineCost In TSVSBaselineCostĪbove is the code I tried to use to store the labor cost in a time scaled array. probably use the Gantt Rows line option in the Gridline dialog. ' ActiveProject.StatusDate = InputBox("Enter the Status Date.", "Status Date", ActiveProject.StatusDate) The rule of thumb is that the timescale is determined based on the earliest start and latest due date of tasks added to the timeline. 'This macro will copy timescaled variance data into the Baseline9Cost field.ĭim TSVBaselineCost As TimeScaleValue 'Capture the dataset for the Baseline10Cost I am trying to time scale the custom cost fields "labor" and "material" so I can view how these data are distributed over a given time horizon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |