Results 1 to 6 of 6

Thread: Exporting from Project 2007 to Word 2003 or Excel 2003

  1. #1
    Join Date
    Sep 2004
    Posts
    15

    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.

  2. #2
    Join Date
    Sep 2004
    Posts
    110

    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.

  3. #3
    Join Date
    Sep 2004
    Posts
    15

    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?

  4. #4
    Join Date
    Dec 2006
    Posts
    489

    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

  5. #5
    Join Date
    Sep 2004
    Posts
    15

    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.

  6. #6
    Join Date
    Dec 2006
    Posts
    489

    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

Similar Threads

  1. Export from MS Project 2003 to Excel 2007
    By Taksal in forum Microsoft Project
    Replies: 4
    Last Post: 08-04-2010, 11:51 AM
  2. How to export a Project 2003 file into Excel 2003
    By destinyswarrior in forum Windows Software
    Replies: 3
    Last Post: 21-03-2009, 05:45 PM
  3. Office Outlook Calendar 2003 and exporting to Word 2003
    By Soumen in forum MS Office Support
    Replies: 1
    Last Post: 15-03-2009, 09:21 PM
  4. Problem with Outlook 2003, Word 2003 & Word 2007
    By PC18 in forum Windows Software
    Replies: 9
    Last Post: 06-02-2009, 08:46 AM
  5. Project 2007 Client Cannot Connect To Project Server 2003
    By PARRISH in forum Microsoft Project
    Replies: 1
    Last Post: 21-02-2007, 10:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,636,186.83595 seconds with 17 queries