Skip to content
ProjectControls.com
Microsoft Project

Export format

In the Open Standard
Stuart AtkinsonMember for 22 years 9 months
Created
3
2
0
Everyone,

One of the projects I am working on requires the use of MSP 2007. I need to know how to export the table information to excel- with the indents in place.

Thanks

Stuart
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1
    Stuart,
    I am afraid you can’t! Task name indentation is a part of the MS Project format for summary and subsidiary tasks
    You could however export the "WBS Index" field together with the other infos, and then write an Excel macro to use this field to indent the tasks in the Excel sheet
    Alexandre
    Report
  2. 0
    Bo Johnsen ·
    #2
    Stuart,

    Here is a link, with a macro from Jack Dahlgren, that might help you:

    http://masamiki.com/project/export-hierarchy-to-excel.html

    Regards,

    Bo
    Report
  3. 0
    Stuart Atkinson ·
    #3
    Thanks everyone. I will try both.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?