Editing Assignment Level Text Fields (2007)

[DMS]

All,
I am new to MS Project 2007. I have been reading several posts this morning
looking for the answer to what I thought was a very simple question; "How do
you programmatically edit Assignment Level Text Fields?"

So I have been reading from various posters that in MS Project 2007 their is
now 2 sets of Assignment Fields (Task/Assignment Fields, and
Resource/Assignment Fields). The former are visible in Task Usage views and
the later is visible in Resource Usage Views. I think I understand the
difference.

The problem is I can only seem to edit the Task/Assignment Text Fields
programmatically and not the Resource/Assignment Text Fields.

The following code does populate the Task/Assignment fields. How would I
edit it to populate both? Thanks in advance.

Sub EditAssignmentText10()
Dim T As Task
Dim A As Assignment

For Each T In ActiveProject.Tasks
If Not T Is Nothing Then
For Each A In T.Assignments
A.Text10 = "Test Text"
Next A
End If
Next T

End Sub

 

[JulieS]

Hello DMS,

See the code posted at FAQ 37 under "Version 2007" at:

http://project.mvps.org/faqs.htm

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[DMS]

Thanks for the quick reply. I am making my way through the code. This is
definetly what I was looking for.

 

[JulieS]

You're welcome DMS. Glad to have helped provide the link and thanks
for the feedback.
Julie