Inserting Project 2003 data into MS Word

[Duane]

I would like to create a table in an MS Word document and have the table data
linked to a MS Project file. For Example, a list of a Resource's activities
or a table containing task and selected information. Is this possible?

Thanks,

Duane

 

[John]

I would like to create a table in an MS Word document and have the table data
linked to a MS Project file. For Example, a list of a Resource's activities
or a table containing task and selected information. Is this possible?

Thanks,

Duane

Duane,
Yes this is very doable. Off hand I can think of a few different ways -
some better than others.

The most basic is a cut and paste. If you can set up a custom view with
the elements of Project data you need, the contents of that view can be
cut and pasted into Word as a picture. Not exactly linked but at least
the data is there.

Another approach, but I don't recommend it, is to use Paste Links to
actually link the Project data to a Word element. I've never tried Paste
Links with Word but I will tell you that Paste Links are quite fragile
and can easily get corrupt. I only mention this method because it is
available and can work under the right circumstances.

Yet another approach is to use an export table. Word can read various
file types and Project data can be saved in different formats. You can
read more about that in the Project Help file.

In my mind though, the preferred approach is to use a VBA macro to
export the data from Project to Word. This method has the most
flexibility and has no stability problems but it does require experience
with VBA.

Hope this helps.
John
Project MVP

 

[Duane]

Thanks,

I would like to use the VBA solution. Do you know of some good sample code
for this proceedure?

Duane

 

[John]

Thanks,

I would like to use the VBA solution. Do you know of some good sample code
for this proceedure?

Duane

Duane,
No, not specifically for exporting Project data to Word. However, I can
suggest a couple of links that might be very useful.

You don't mention if you have VBA experience or not but even if you do,
you might want to take a look at the link on our MVP website for Project
VBA. Go to: http://www.mvps.org/project/links.htm
At the bottom of the page you will find a link for, "Project 98 Visual
Basic Environment Training Materials". Even though it says it is for
Project 98, it is equally applicable to all current versions of Project.
As I recall, the training modules help explain the Project object
structure and there is also a section on how to interface with other
applications.

A second link to to fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
Jack has several examples of useful VBA code. In particular the macro on
exporting Project data to Excel (Export hierarchy to Excel) might be of
benefit.

Good luck. If you have further questions, feel free to post in our
related newsgroup: microsoft.public.project.developer

Hope this helps.
John
Project MVP