Microsoft Office Forums - View Single Post - Accessing Assignment Detail Data in Task Usage View

CGM3 · 10-05-2010, 05:56 AM

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

-- but that returns the total hours for the task on that day, even if the active row is an assignment. I also came across
the SelectTimescaleRange method --

Code:

             SelectTimescaleRange lRow, strStart, iNbrDays, 1

-- but can't figure out how to access or reference the range it selects (the documentation refers to a 'usage view' but
gives no example.)
Any suggestions?