Linking Excel cells to a Word document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jada - 14 Nov 2005 13:03 GMT

I would like to create a word document which I can link to certain cells in
an excel document. For example imagine I created an empty table in word. I
would like to link some of the cells of this table to certain cells in an
excel spreadsheet.
and once I link them I would like to assign a key to the function like an F
key maybe and perform the transfer of the cells at once.
The main purpose is to create a visual document in Word and keep the data in
excel and mapping certain cells to eachother and finally hitting one key to
make the transfer. As the excel table is updated with live data I should be
able to update the word documewnt as well by hitting one key. I am not sure
if I should do this by mail merge or by assigning macros. If I need to assign
macros (which I tried but was unsuccessfull in mapping) could you tell me
how, for example walk me through the mapping of one cell and I can do the
rest....Many Thanks....

Reply to this Message

Graham Mayor - 14 Nov 2005 13:58 GMT

You can certainly link Excel cells into a Word document - paste special/as
link and while both the document and the spreadsheet are open any changes to
Excel are immediately reflected in Word. I would, however, recommend that
you perform all the calculations in Excel and insert the complete table
rather than insert individual cells into a Word table, or you may have
problems with the formatting.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I would like to create a word document which I can link to certain
> cells in an excel document. For example imagine I created an empty
[quoted text clipped - 11 lines]
> me through the mapping of one cell and I can do the rest....Many
> Thanks....

Reply to this Message

jada - 14 Nov 2005 15:15 GMT

First of all thanks for your reply but when I do copy paste instead of
pasting a limk or function it pastes the information directly from my excel
spreadsheet. I belıeve I need to use a macro which can copy data from
dirrerent tabs in excel into different cells in word and do it at once by
hitting one key. The problem is I cannot remember exactly how it is done. I
start recording a macro but as I do the copy pasting it seems to not
function...İf you could help me with this I would highlt appreciate it.

Jada

"Graham Mayor":

> You can certainly link Excel cells into a Word document - paste special/as
> link and while both the document and the spreadsheet are open any changes to
[quoted text clipped - 18 lines]
> > me through the mapping of one cell and I can do the rest....Many
> > Thanks....

Reply to this Message

Doug Robbins - Word MVP - 14 Nov 2005 20:17 GMT

See the article "Control Excel from Word" at:

http://www.word.mvps.org/FAQs/InterDev/ControlXLFromWord.htm

and "Control Word from Excel" at:

http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm

Signature

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

> First of all thanks for your reply but when I do copy paste instead of
> pasting a limk or function it pastes the information directly from my
[quoted text clipped - 34 lines]
>> > me through the mapping of one cell and I can do the rest....Many
>> > Thanks....

Reply to this Message