Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2010, 05:56 AM
CGM3 CGM3 is offline Accessing Assignment Detail Data in Task Usage View Windows XP Accessing Assignment Detail Data in Task Usage View Office 2007
Advanced Beginner
Accessing Assignment Detail Data in Task Usage View
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default 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
-- 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?
Reply With Quote
Reply

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 Assignment Detail Data in Task Usage View accessing out from NAS bradleyh10 Outlook 1 05-30-2009 11:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft