Exporting from Project 2007 to Word 2003 or Excel 2003
On my windows 7 PC I am using Office 2003 and MS Project 2007. I’ve created a project consisting only Rows and Columns and Gantt Chart. I wanted to know whether it is possible to export this project task to Excel 2003 or Word 2003. If it is possible please let me know how can I export the same with retaining the text formatting as well as in a tabular form?
Thank you.
Re: Exporting from Project 2007 to Word 2003 or Excel 2003
I have done this earlier and it was very easy. In order to export project in Excel 2003 just click on File > Save As > Save as type : Microsoft Excel Workbook > Save. Now you will see a wizard which will allow you to create map Project's fields to Excel columns. That’s it. If you want to export the same in MS Word than you will need to write a VBA Macro.
Try out and reply back with the result.
Re: Exporting from Project 2007 to Word 2003 or Excel 2003
Thanks for the help Chapal, but I stated in my above post I don’t want to lose the text formatting, following your steps is losing the formatting. Can you please tell me some another way which can allow me to keep the bold Summary Tasks bold in the Excel sheet?
Re: Exporting from Project 2007 to Word 2003 or Excel 2003
Hello Jasper W,
Although you said in your initial post that you weren't looking for a VBA answer, fellow MVP Jack Dahlgren has posted a sample macro (VBA) to accomplish part of what you seek. You can find the macro and additional information at Jack's site:
http://masamiki.com/project/macros.htm
Look for the macro "Export Hierarchy to Excel". I hope this helps. Let us know how you get along.
Julie
Project MVP
Re: Exporting from Project 2007 to Word 2003 or Excel 2003
Hi Julie,
Thats exactly what i needed. Thank you so very much. I was able to run the
macro and export an Excel worksheet with no blank rows. I really appreciate your help.
Re: Exporting from Project 2007 to Word 2003 or Excel 2003
You're most welcome Khindaria. If you've decided to learn VBA for
Project, I suggest investing in Rod Gill's excellent book. See:
http://www.projectvbabook.com
Thanks for the feedback.
Julie