External links/inserted Project & Excel Export

[RC]

Hello,

I have a macro that exports timescaled data to Excel. It works fine -
until today when I ran into a schedule with external links. Which also
has an inserted project.

Is there a way to access the external links and export the timescaled
data? Or is On Error Resume Next my best option.

Is there a way to access the inserted project to export the timescaled
data?

Thank you for any guidance!

RC

 

[RC]

I think I have the inserted project part down ... on to the external
links!

RC

 

[DanSmoach]

Dear RC

Would it be possible to post your macro code? I have been trying to produce
a macro to do this, but i haven't been able to get it to work. I am trying to
export task name, resource name and peak units across weeks.

Thanks

Dan

 

[RC]

Dear RC

Would it be possible to post your macro code? I have been trying to produce
a macro to do this, but i haven't been able to get it to work. I am trying to
export task name, resource name and peak units across weeks.

Thanks

Dan

Hi Dan,

I'm pretty new to VBA, but I've learned so much from people on this
forum - so I hope I can help you! For details, please check out the
TimeScaleData method. A good bit of the macro is pretty company
specific, so I'm posting little parts that I think you may need.

'Use this to loop through tasks in the area
OutlineShowTasks expandinsertedprojects:=True
SelectTaskColumn
Set Area = ActiveSelection.Tasks

For Each t In Area

If Not t Is Nothing Then
'Do stuff like print task name
For Each Asgn In t.Assignments
'Do stuff like print resource name

Set aTsvs = Asgn.TimeScaleData( _
StartDate:=ActiveProject.ProjectSummaryTask.Start,
_
EndDate:=ActiveProject.ProjectSummaryTask.Finish,
_
Type:=pjAssignmentTimescaledWork, _
timescaleunit:=pjTimescaleMonths, _
Count:=1)
'This will retrieves Assignment Work data by
month. You could probably use pjAssignmentTimescaledPeakUnits instead.

Please let me know if maybe a different part is what you needed help
on. Hope this helps!

RC