Creating a list of predecessors for each milestone

I'm looking to build a list of predecessors for each milestone in every subproject file that is contained in a consolidated file that is not complete. I'd like to export the list to excel. Thanks

I have a macro that creates a logic report in Excel. It shows each task, with predecessors above and successors below. Do you think you could use this? You could add an If Task.Duration=0 to get only milestones.
Email me at onetruerick2008@yahoo.com and I will send it to you.

Were you able to use it? What did you think?