Excel formatting for Task list

[Jonathan]

I'm using PJ2002, and couldn't find the answer to this in Help or this forum,
so thank you for your patience if it's an old chestnut.

A colleague does many projects and wishes to export them to XL2003 for
working on and dissemination. When I Save As an Excel file and follow the
wizard it produces just the right listing but it loses the formatting of the
different cells, as in fonts and especially indents to distinguish tasks and
subtasks in PJ. Copy and paste lets me insert a picture of the tasks or the
unformatted task list. How can I do this without a macro?

 

[Rob Schneider]

I'm using PJ2002, and couldn't find the answer to this in Help or this forum,
so thank you for your patience if it's an old chestnut.

A colleague does many projects and wishes to export them to XL2003 for
working on and dissemination. When I Save As an Excel file and follow the
wizard it produces just the right listing but it loses the formatting of the
different cells, as in fonts and especially indents to distinguish tasks and
subtasks in PJ. Copy and paste lets me insert a picture of the tasks or the
unformatted task list. How can I do this without a macro?

Export from Excel, losing formatting (since Project won't set the
format). In Excel, import from the file created by Project into another
spreadsheet range that is formatted. Do all this formatting in Excel.

 

[Jan M.]

Jonathan,

here's a workaround I frequently use.

Instead of saving as an excel file, save as Web Page. The wizard will guide
you through the same steps but the results will be a "formatted" Web Page.

Just copy and paste in excel: the formats will follow (Indents, bold
caracters...).

HTH.

Jan M.

 

[Jonathan]

Thank you Rob, Mike and Jan for three fast and useful answers. I used Jan's
workaround for the immediate problem and will examine the links you gave me.
And I now understand references elsewhere to 'Jack's Macro'