Linking

V

Vicki Zetrouer

I would like to be able to link a cell in a table in Word to a task number or
description in Project. Is there any way to do this?
 
J

Jim Aksel

Here is one way we've done in the past.
In Project 2003, save your .mpp file as a webpage (.html). This is not
available in P2007.
Open the webpage in an editor such as FrontPage, Expressions Web, Dream
Weaver. Add a bookmark to the file in the location of interest. This is
done in the HTML editor.

In Word, make a hyperlink. You can specify the bookmark in the Hyperlink
properties in the Word document.

Since that may not give you the view you are looking for, you can specify in
the Word Hyperlink to open the MPP file directly. So, when you select the
link, it will wake up Project. If necessary, adjust your project file to
open in a specific view that is useful for you.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 
J

Jim Aksel

Now I understand. So, if you have a Project1.mpp file you want to report a
portion of one task in Word.doc. Something like, if the %Complete for Task37
changes, you want that to be visible in your Word document dynamically.

The shortest answer is "No." But you may want to try this. Project Files
are viewed as Objects to Word. So, you can insert the file (yes, the entire
file) as an Object in the Word.doc file. In Word go to Insert/Object....
You can browse to Project1.mpp. Specify Link in the check box.

What you have now is a partial view of the Project1.mpp in Word.doc.
Clicking on the object in Word.doc wakes up Project and Project1.mpp. So,
that gets the dynamically linked data.

Now, formatting it to show only what you want. In Word.doc, right click on
the Project1.mpp object and select Format Object. This will allow you to
change the size, location, etc. You should be able to adjust the window to
show the area of the object desired. Remember, you can also work in
conjunction with Project to filter and create a custom view. This will also
change what is displayed in Word.doc.

Unfortunately, the Dynamic Linking between the two files is not much more
robust than that; it is not possible to link to a portion of an object.

Approach #2

You can write some VBA code in Word that will go wakeup the Project1.mpp
file and extract a bit of data. You can then plug that data bit onto the
face of your Word.doc using VBA in Word. You should post to the Word group
for VBA assistance in that area. The Developer section of this group can
show you how to instantiate Project and wakeup your Project1.mpp file all in
the background.

I suppose you could solve the problem in reverse by doing the VBA in Project
and have Project wakeup Word.doc and jam the information to a known spot.

I've done my best to answer your question, now some advice. Don't do it.
It's not worth the effort. You need to constantly monitor the location of
both files to make sure the link stays alive. You'll spend your time
tinkering with it and you have more important work than this.

You will probably be better served if you use the Copy Picture wizard in
Project. It is available on the Standard Toolbar. You can limit to one task
if you wish. This will copy a bitmap to your clipboard and you can paste
that into Word.doc. It is a static image, it takes seconds to create, and
you have more control.

You can also do the same with screen clipping software available in Vista,
or a product like SnagIt also works well.

I suppose the real question is, how important is the dynamic link to you?
You might want to cross post to the Word group to see if anyone there has a
solution.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 
C

Colin

Vicki

I agree with Jim on the preference to not use links. But if you must - Have
you tried copy/paste.

Copy the required cell from the table in MSP
Paste special in word - Select paste link (text)

Colin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top