B
Billy
I have found the following code:
For Each R In Proj.Resources
For Each A In R.Assignments
xlR.Range(headercolumns) =
Array(A.ResourceName, A.TaskName, ProjectName, A.Work / 60, A.Cost)
'Export Time Phased Data
Set Tsvs =
A.TimeScaleData(DateSerial(Year(Date), Month(Date), 1), _
DateSerial(Year(Date), Month(Date) +
12, 1 - 1), _
pjAssignmentTimescaledWork,
pjTimescaleMonths)
I don't understand what the Array item is in the 3rd line down. Is
that a Microsoft VBA function or method or a specific variable or
what. Please explain.
See the total code at http://office-watch.com/project/archtemplate.asp?3-20.
For Each R In Proj.Resources
For Each A In R.Assignments
xlR.Range(headercolumns) =
Array(A.ResourceName, A.TaskName, ProjectName, A.Work / 60, A.Cost)
'Export Time Phased Data
Set Tsvs =
A.TimeScaleData(DateSerial(Year(Date), Month(Date), 1), _
DateSerial(Year(Date), Month(Date) +
12, 1 - 1), _
pjAssignmentTimescaledWork,
pjTimescaleMonths)
I don't understand what the Array item is in the 3rd line down. Is
that a Microsoft VBA function or method or a specific variable or
what. Please explain.
See the total code at http://office-watch.com/project/archtemplate.asp?3-20.