![]() |
|
#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? |
|
|
Similar Threads
|
||||
| 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 |
accessing out from NAS
|
bradleyh10 | Outlook | 1 | 05-30-2009 11:52 PM |