Text Fields between Gantt and Resource View

[deluth]

I'm currently using MSP2003. Is there any way I can make the Text field be
the same in the Gantt view as it is in the Resource Usage View? I want to be
able to share a text field between these views but don't know how to do it.
It was confusing to find out that they were all named "text1 - text30" but
were not the same thing across different views.

I also have a macro that manipulate a value in one of the field in the Gantt
view but doesn't work correctly in the Resource Usage View. Maybe it's part
of the same problem...

Thanks in advance! Deluth.

 

[Mike Glen]

Hi Deluth,

Welcome to this Microsoft Project newsgroup

You might like to see FAQ Item: 37 - Custom Fields in Tables. FAQs,
companion products and other useful Project information can be seen at this
web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on

Mike Glen
Project MVP
?

 

[Brian K - Project MVP]

I'm currently using MSP2003. Is there any way I can make the Text
field be the same in the Gantt view as it is in the Resource Usage
View? I want to be able to share a text field between these views
but don't know how to do it. It was confusing to find out that they
were all named "text1 - text30" but were not the same thing across
different views.

I also have a macro that manipulate a value in one of the field in
the Gantt view but doesn't work correctly in the Resource Usage View.
Maybe it's part of the same problem...

Thanks in advance! Deluth.

Does the macro you have put Task Text field values into the Assignment
Text fields so they can be seen in the Usage View? If so that macro can
be easily redone to put resource text fields in as well. But they
cannot be used at the same time since one puts resource fields in and
one puts task fields in. The only way both can work is if One set puts
the (for example) Task Text 1 field into the Assignment Text1 field and
then the other puts the Resource Text 1 field into Assignment Text2.
Then you could have both working together.

Here are macros that will do what you want (I think). One for tasks and
one for resources. you will need to edit the "Text1" parts to get them
right for your situation.

Sub RestoAssn()
Dim R As Resource
Dim A As Assignment

For Each R In ActiveProject.Resources
If Not (R Is Nothing) Then
For Each A In R.Assignments
A.Text1 = R.Text1
Next A
End If
Next R
End Sub

Sub TasktoAssn()
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.Text2 = T.Text1
Next A
End If
Next T
End Sub

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com

 

[deluth]

This worked great! Unfortunately, it didn't work for the assignments that
were not assigned - the "unassigned" tasks. Is there some way of getting the
text value to line up for these?

Deluth
===============