how do i "look up" an associated value for a task id

[JulieD]

Hi

trying to output assignment information to excel (can do), but in addition
to the assignment fields, i would also like to output additional task fields
and i'm guessing that i can use the

ActiveProject.Resources.Assignments.TaskID

field to link to task text1 field, but i've got no idea how, ... help please
....

 

[Jan De Messemaeker]

Hi Julie,

Just to give an idea:

Activeproject.tasks(Activeproject.resources(5).assignments(3).taskid)

Hope this helps,

 

[JulieD]

Hi Jan

thanks, worked perfectly