Data-Exchange between Excel and Word-Documents

[Tini]

Hello,

I have the following problem. I need something, which
generates a Word-Document with information from the Excel-
sheet. Do you know some help?

Tini

 

[Mike]

How much information from Excel do you need? There are
many options.

The most simple would be to copy from Excel (Ctrl+C) then
paste into Word (Ctrl+V).

Or from the Word menu, you could try Insert/File, select
All File types, browse for your Excel file, click OK then
pick the sheet you want to copy over. Formatting is lost
when you do this though.

Another option is to drag the Excel file from Windows
Explorer into a Word document. You don't loose the
formatting, but it may not fit nicely. What you've done
here is embed a copy of the worksheet right into the Word
document, and you can edit it as if it were an Excel file
by double-clicking on it (Formulas, formatting, the whole
works).

 

[Tini]

You misunderstood me.

What I need is the following:

Every row has one icon. Then I want to choose one of it
and click. Then a Word-Document opens and depending on the
row-number I'll be at the right position. Then there
should be added some short Information from the chosen
excel-row and four titles, which shoud be every time the
same. Under these titles the user have to put in some
text. And that's it. If the numbers change in the Excel-
sheet it have to change also in the Word-Document!

Is something like that possible, or sounds it like I'm
dreaming?

Tini

 

[Jon Peltier]

Tini -

It certainly is possible, if I understand your description. It will
take you a little while to learn the details, but from Excel you can
open a Word document, and move to the place where you want the user to
type. If there's no exchange of information between the applications, I
wonder if you could do it more easily from a Word document, and maybe
use a hyperlink to a bookmark in the target document.

I have a few notes and examples of the use of Excel with other Office
applications on my web site. This page doesn't show what you want, but
it might be a good place to start. You could also try google with the
key words Excel Word Automation, and get lots more examples.

http://www.geocities.com/jonpeltier/Excel/XL_PPT.html

- Jon