P
Peter Rooney
Apologies to Mr Messemaeker for hacking his code into a non-working format!
I have a text field in my Gantt view that I want to show in my Resource
usage view.
Last week, Jan kindly gave me some code to display Duration in Resource
Usage view, which I thought I'd modified to do what I want - but not quite..!
The field in Gantt View I want to bring in is Text9, AKA "CR/TWR"
The field in Resource Usage I want to bring the information into is Text1
Sub AssignTWR()
Dim Job As Task
Dim MyTask As Assignment
For Each Job In ActiveProject.Tasks
If Not Job Is Nothing Then
For Each MyTask In Job.Assignments
MyTask.Text1 = MyTask.Text9
Next MyTask
End If
Next Job
End Sub
I know whay this doesn't do anything - it makes Text1 in Resource Usage
equal Text9 in Resource Usage, - as the latter is empty, Text1 stays empty,
too! - I want it to equal Text9 from the Gannt view!
Cheers
Pete
I have a text field in my Gantt view that I want to show in my Resource
usage view.
Last week, Jan kindly gave me some code to display Duration in Resource
Usage view, which I thought I'd modified to do what I want - but not quite..!
The field in Gantt View I want to bring in is Text9, AKA "CR/TWR"
The field in Resource Usage I want to bring the information into is Text1
Sub AssignTWR()
Dim Job As Task
Dim MyTask As Assignment
For Each Job In ActiveProject.Tasks
If Not Job Is Nothing Then
For Each MyTask In Job.Assignments
MyTask.Text1 = MyTask.Text9
Next MyTask
End If
Next Job
End Sub
I know whay this doesn't do anything - it makes Text1 in Resource Usage
equal Text9 in Resource Usage, - as the latter is empty, Text1 stays empty,
too! - I want it to equal Text9 from the Gannt view!
Cheers
Pete