material resource assigned at 5/day

[Robert]

Hello,
I need to assign (via VBA) a material resource to the selected task. For ex.
5 units/day
In the following setting, how can I say that I want to assign the MatRess at
5/d ?
ActiveSelection.Tasks(1).Assignments.Add ResourceID:=MatRes, Units:=????

Thanks for your help

 

[Jan De Messemaeker]

Hallo Robert,

Sorry, I fail to see how you could use assignments.add to do this directly
But once the assignment is created (with any units value) the following
works:
activeproject.Tasks(1).Assignments(1).Units="5/d"

When, as in your example, the task is selected, you can use the
resourceassignment method which also accepts 5/D as units.

Hope this helps

 

[Robert]

Thanks Jan,

Eventually, the following setting worked for me :
ResourceAssignment Resources:="MatRes[" & nb & "/j]"
where nb is a variable.

Rob

 

[Jan De Messemaeker]

Hi,

Glad you made it work!

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Thanks Jan,

Eventually, the following setting worked for me :
ResourceAssignment Resources:="MatRes[" & nb & "/j]"
where nb is a variable.

Rob

Hallo Robert,

Sorry, I fail to see how you could use assignments.add to do this
directly
But once the assignment is created (with any units value) the following
works:
activeproject.Tasks(1).Assignments(1).Units="5/d"

When, as in your example, the task is selected, you can use the
resourceassignment method which also accepts 5/D as units.

Hope this helps