Post your responses in the original thread. HTH Otto
"Wilson" wrote in message
...
Don -

This is fantastic... your macro has really helped me out! thanks!

I have a new twist though....I need some additional functionality. Any
help
would be appreciated.

I need to Copy this data from MSP into Excel:
ID|Name|Duration|Rem. Duration|Successors|Finish Date|Actual Finish

#302|Task E|9 d|2 d|#1200,#475,#949|08-14-08|N/A
#420|Task K|7 d|7 d|#520,#2003,#399,#293,#378|08-21-08|N/A

Run a version of your macro to spit out the following:

Row1:Task Detail for #302 (i.e. Task E|9 d|2d|...)
Row2:#1200
Row3:#475
Row4:#949
Row5:Task Detail for #420
Row6:#520
Row7:#2003
Row8:#399
Row9:#293
Row10:#378

Currently... the macro will take the successors that are stored in a
single
field (separated by commas) and assign them each to a row directly below;
however, I'm not able to retain the additional task detail. With the
current
Macro, I can only have two columns of data (i.e. Name | successor or ID |
successor)...