Writing actual values for an assignment between 2 dates in VBA

[David]

Hello,
In Project VBA, I'm trying to find an easy way of updating resource
assignments with the latest actuals (work and cost) between the start date of
the assignment and the Project status date (for non finished tasks).

Any ideas that would help me?

Thanks in advance
David

 

[Rod Gill]

You need the timescaled method for the assignment. It gives you data you see
in the Useage views.

 

[David]

Thanks. I think I got it for the most part. Could you tell me if the lines
below will help me reach my goal. Will The actual cost and work spread
evenly between the 2 dates and be posted on the resource working days?

RA is the current resource assignment I want to update.

Set TSV = objRA.TimeScaleData(StartDate:=TSStart, EndDate:=TSStop) 'DM:
Added line
TSV.Parent.ActualCost = TSPeriodCost
TSV.Parent.ActualWork = TSPeriodQty

 

[Jan De Messemaeker]

Hi,

Using Timescaledata, costs will not be spread.
It gives you the opportunity to enter the costs like tyou would enter them
in a Usage View (Task or Resource)
You must specify which is the granularity of the timescale values
Then you can start entering data into TSV (which is a collection!)
TSV(1).value=
TSV(2).value=

etcetera

Defiinitely NOT parent which makes you lose the timescaled aspenct
altogether.
HTH