#1
|
|||
|
|||
Accessing Assignment Detail Data in Task Usage View
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 Tools | |
Display Modes | |
|
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 |