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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Julie,

Thanks for your tip. I was able to copy-paste the script into a module in
VBA editor and run the macro. The resulting Excel *** shows the Summary
Tasks in bold and puts the Subtasks (not in bold, as required) in next column
and up to this it is wonderful. There are 2 issues I am running into -

a) The macro adds a row between each task. I cannot sort in Excel or else I
will lose the connectivity between Summary Tasks and their respective Subtasks
b) I am not getting the Start and Finish Date columns by running this macro

I have step away from the computer and will be able to work on it on Monday
only. If you have any suggestions, would appreciate it greatly. If not, I
guess I will use the Export Wizard to extract the date columns and add the
columns.

Thanks a ton. A lot of what I need has been accomplished.
Khindaria

"JulieS" wrote:

Hello khindaria,

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

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

"khindaria" <khindaria@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3ABE41E5-DA2C-4B78-BAE8-F918621F0067@xxxxxxxxxxxxxxxx
Hi Gérard,

Thanks for replying. I tried that but I lose text formatting.

The Project document shows Summary Tasks in bold and Subtasks
indented. When
I save Project document and use Export Wizard, it creates an Excel
*** with
all tasks unformatted. I have to manually make all Summary Tasks
bold and
indent all Subtasks. With more than 100 tasks and needing to do
this 2-3
times every week, I would use a lot of time working the Excel
***.

Is there any way I can keep the bold Summary Tasks bold in the
Excel ***.
I can figure a way to indent the Subtaasks by using macros or
something.

Thanks,
Sanjeev

"Gérard Ducouret" wrote:

Hello Khindaria,

Exporting data into Excel is easy:
File / Save As... / Save as type : Microsoft Excel Workbook
Click Save
Then follow the wizard to buils to map Project's fields to Excel
columns
To export data into Word, you have to write a VBA macro...
Hope this helps

Gérard Ducouret

"khindaria" <khindaria@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
message de
news: E077875E-22F3-473B-85EC-95167A055F94@xxxxxxxxxxxxxxxx
Is there a way to export a view (table comprising of rows and
columns with
data only, without the Gantt Chart bars) from Project 2007 to
Word/Excel
2003
in a tabular form and retaining the text formatting?

Need the table exported into Word/Excel editable so am not
looking for a
GIF
or TIF image. I have never used VBA scripts so am looking for
non-VBA
solutions.

I do have Adobe Acrobat and tried creating PDF and then using a
PDF
converter to create a Word document but most PDF converters do
not retain
the
columns properly and some lose text formatting also.

Thanks,
Khindaria






.

Quantcast