change the assignment work in timescale

[Hernandezz]

Hi.

I haved seen a lot of posts with questions about how export data from
timescale.

I use project 2007 and my question is about, how to change the
assignment work for a specific resource in a specific day.

Example:

work assignment =40h
duration assignment = 5 days
monday =8h, tuesday=8h...friday=8h

then i want for example change the monday work to 7h, and friday to
9h, all within timescale in resource usage. it's possible with VBA?

Thanks,

Best Regards

 

[Vivek Gupta]

Hi,

Yes it will be possible.Although this method can be used in task usage view
and not resource usage view using timescaledata.

You will need to obtain the task object and the corresoonding assignment
object for the task for which you want to set actuals.
In the following code,I am setting work for a task assignment for a given
task on 10th feb 2009(1 hrs) and 11th feb 2009(2 hrs).The task is the first
task in project.

Dim w_timescaleobj As TimeScaleValue
Dim w_timescalecolln As TimeScaleValues
Dim w_assgnobj As Assignment

Set w_assgnobj = MSProject.ActiveProject.Tasks(1).Assignments(1)
Set w_timescalecolln = w_assgnobj.TimeScaleData("2/10/09", "2/10/09",
pjAssignmentTimescaledlWork,pjTimescaleDays)
w_timescalecolln.Item(1).Value = 60 '(60 =60 min= 1 hr)

Set w_timescalecolln = w_assgnobj.TimeScaleData("2/11/09", "2/11/09",
pjAssignmentTimescaledWork, pjTimescaleDays)
w_timescalecolln.Item(1).Value = 120

Let me know if it helped.

Regards,
Vivek Gupta
MCTS for Project 2007