Exporting Predecessors

[Randy]

I was wondering if anyone had a MS Project macro to put each predecessor in a
seperate text or number field so I can export to Excel.

 

[davegb]

I was wondering if anyone had a MS Project macro to put each predecessor in a
seperate text or number field so I can export to Excel.

Since every task but your Finish milestone should have a predecessor,
every task except the Finish milestone should be in your list. Just
export them to XL.

Hope this helps in your world.

 

[Randy]

Sorry, I wasn't clear in my request. I would like each predecessor in a
seperate column in Excel. I havn't found a way to do that in MS Project 2003.
The current method is exporting to Excel with all predecessors in one column
and using the text to columns in Excel to put each one in a column of it's
own.

 

[davegb]

Sorry, I wasn't clear in my request. I would like each predecessor in a
seperate column in Excel. I havn't found a way to do that in MS Project 2003.
The current method is exporting to Excel with all predecessors in one column
and using the text to columns in Excel to put each one in a column of it's
own.
--
- Randy







- Show quoted text -

Copy the task names, then do an "Edit, PasteSpecial, Transpose".

 

[davegb]

Copy the task names, then do an "Edit, PasteSpecial, Transpose".- Hide quoted text -

- Show quoted text -

Should have put, "Copy the task names, then do an "Edit, PasteSpecial,
Transpose in XL"