Hello,
Does anyone know how I can export, copy/paste, an MS Project file to Excel and retain the WBS structure? Summary tasks bold, child tasks indented, etc.
My current workaround is to add the WBS column to the Project file and copy/paste into Excel. Then I have to manually indent and bold.
Thanks and be well,
Eric
Good to hear this help. Please keep in mind that in MSP 2007 this will not work because the ability to save a .mpp file as HTML was eliminated. In MSP 2010 you can achieve an export keeping the WBS structure using copy and paste into Excel.
Hemanth is correct, however, his method it will only apply to 2010 MS Project. However, if you are using 2003 there is a way of doing this. Here is an article that I wrote a few years ago. I will only work for 2003 because the ability to save a file as HTML was removed in 2007. In all versions the export function will not maintain the structure.
http://www.lehnertcs.com/pdfs/200804_ezine.pdf
There is also many tips and trick articles that would be of use for all levels of MS Project. Help yourself.
www.lehnertcs.com.
Ellen Lehnert
MS Project MVP
Thanks, That answers my question and allows me to "export" the WBS structure from MSP to Excel--version 2003 MSP.
Hi Eric,
If you're using 2k3 try this workaround.
http://www.lehnertcs.com/pdfs/200804_ezine.pdf
Regards,
Darren
2003 MSProject does not have the MSProject to Excel and maintain the task heirarchy feature that 2010 has.
In MSP 2010: Show all columns in MSP and just copy it and paste in Excel .
For Better Presentation, Group the Activities in MSP, Then Copy Paste
All Horizontal bands will be there with all the text formats and color ( Only vertical bands will be missing )
Not Tried In MSP 2003