![]() |
#1
|
|||
|
|||
![]()
Does anybody know how to access or reference (in VBA) the detail data for an assignment row when in the Task Usage View ?
I've tried using TimeScaleData -- Code:
Dim TSV1 As TimeScaleValues SelectTaskField lRow, "Name", False strStart = Format(dStartDate, "m/d/yyyy") strEnd = Format(dEndDate, "m/d/yyyy") Set TSV1 = ActiveCell.Task.TimeScaleData(strStart, strEnd, pjTaskTimescaledWork, pjTimescaleDays, 1) lHowMany = TSV1.Count If lHowMany > 0 Then For lJ = 1 To lHowMany iHr1 = (Val(TSV1(lJ).Value) / 60) ' Work (forecast) ... Next End If the SelectTimescaleRange method -- Code:
SelectTimescaleRange lRow, strStart, iNbrDays, 1 gives no example.) Any suggestions? |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Resource Usage sheet - options | Andy Bain | Project | 1 | 11-05-2010 12:42 PM |
Setting an Assignment Field from VBA | CGM3 | Project | 1 | 10-05-2010 05:51 AM |
Help needed with assignment | ccmystery | Outlook | 0 | 04-09-2010 05:59 AM |
tafe assignment | alharris | Word | 0 | 11-16-2009 12:00 AM |
![]() |
bradleyh10 | Outlook | 1 | 05-30-2009 11:52 PM |