Access Assignment Enterprise Field Values

[Darren_S15]

I’ve got a project 2007 plan that is an export of a project server
2007 plan.

In the project server plan they have made use of the Enterprise
Fields.

Unfortunately I need to access these fields in my .mpp file using
VBA.

I’ve managed to work out using "ActiveProject.Tasks(1).GetField
(FieldNameToFieldConstant("Custom Field", pjTask))" that I can access
these fields to get the values for tasks and resources.

However on the task usage view of the project plan there is only a
value in the enterprise field against the assignments and not the
actual task.

Here is my problem.

I want to take the value that only appears on the assignment line of
the enterprise field and copy into the task line.

So I need to find out how can I access the values that I can see
against the assignments values because the assignment objects do not
have a GetField method.

I did find a forum post saying using the standard a.FIELD_NAME
assuming you have no spaces in your enterprise field's name, but this
does not appear to work for me.

Any help greatly received.

Sorry for the long post,

Darren

 

[Darren_S15]

Does no one know how to do this?

It must be possible because the saved Project file must store these
values somewhere?

No matter how much I search the web I cannot find anything that works.