[Doug Robbins - Word MVP]

I am thinking that this thread was started several years ago. It might be
best if you started a new thread and explained in it exactly what it is that
you want to do.

Where are the headings that you might choose? With what is each individual
heading associated?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Kesbutler" wrote in message
...
Your idea below about running a macro to generate a word doc might
actually
be what I am looking for. How would I do this. I need to generate a word
doc
based of off which headings I choose.

"Ed" wrote:

What if you drive all of this from Excel? I'm assuming that one of
daunting
parts is automating all the "Blah Blah" stuff? I can name an entire
range
in Excel and paste a link into a Word doc - any changes to the range,
including inserting and deleting rows are reflected in the link in Word.
If
you run all of this as
List Item 1
Blah Blah
List Item 2
Blah Blah
etc. in Excel, you can link that column into Word and any adjustments are
reflected in the doc.

You could also do something like putting your List Item in Column A (in
Excel) and your Blah Blah in Column B, then put a check mark in Column C
for
every one you want to include, then run a macro in Excel that would
generate
a Word doc based on whatever template, letterhead, etc you desire with
only
the checked items. Although that sounds a lot like trying to imitate an
Access report.

Ed

"heyz" wrote in message
...
Hi jezebel

Thanks again. Yes that works. I have discovered today with ur help.
Unfortunately I assess that to achieve what i had in mind I'm going to
have
to work on automating too many things. And tat might be more work than
doing
what I intend to do without all the automation.
For example if i inserted a new list my word file wouldn't correspond
to
that change. The content under one list item would show up under a
previous
list item. In short more work developing all this.
Thanks a lot though. I am sure i'l be using what i learnt someway or
the
other

heyz

"Jezebel" wrote:

Press Alt-F9 to display field codes. You'll see the the link looks
something
like this --

{ LINK Excel.Sheet.8 "d:\\username\\Temp\\Book1.xls" "Sheet1!R3C3" \a
t }

If you give the Excel cell a name, you can insert that name in place
of
the
"Sheet1!R3C3" part. Then the link will reference the cell with that
name,
wherever it is.



"heyz" wrote in message
...
Hey Jezebel

Thanks so much for that! It simplifies things a lot.
However, I have managed to find myself in one more problem: I tested
this
method and found that if I add rows or columns in such a way to
change
the
position of the original cell then the linked field in Word does not
automatically catch that change (but linked cells in other sheets
within
excel seem to catch the position change and properly reflect it) Is
there
a
way to get around that?

And thanks again.

heyz

"Jezebel" wrote:

Select and copy the cell in Excel. Switch to Word and use Edit
PasteSpecial, with the 'Paste Link' option checked.



"heyz" wrote in message
...
Hi

I have an excel sheet that has some database and which will keep
getting
updated. I have another Word file that is based on the database
of
the
excel
sheet. The purpose of using word is that I will have content
written
for
each
of the database element from excel. I am wondering if i could
link
excel
and
word in such a way that Any update in excel will automatically
make
the
update in word. I tried Inserting Excel as an object but that
inserts
the
sheet as a whole. What i am looking to achieve is inserting
cells
in
different places of the word document.

Let me illustrate my situation

Say my excel sheet is like
=========
LIST ITEMS
=========
List Item 1
List Item 2
List Item 3

And my word Document is

=========
List Item 1
=========
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah

=========
List Item 2
=========
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah

=========
List Item 3
=========
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah Blah
Blah
Blah
Blah Blah Blah Blah Blah Blah Blah Blah Blah

Obviously, am gonna have lots of these List Items which is why I
am
trying
to automate it.

Is this possible? Or is it wishful thinking.
Thanks for any suggestion.