Help!

Linking Excel cells to a Word document

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields RSS
Next:  MACRO for CHECKBOX FORM FIELD  
Author Message
jada
External


Since: Nov 14, 2005
Posts: 2



PostPosted: Mon Nov 14, 2005 10:03 am    Post subject: Linking Excel cells to a Word document
Archived from groups: microsoft>public>word>mailmerge>fields (more info?)

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....
Back to top
Graham Mayor
External


Since: Jan 07, 2004
Posts: 2903



PostPosted: Mon Nov 14, 2005 5:15 pm    Post subject: Re: Linking Excel cells to a Word document [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.


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

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


jada wrote:
> 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....
Back to top
jada
External


Since: Nov 14, 2005
Posts: 2



PostPosted: Mon Nov 14, 2005 5:15 pm    Post subject: Re: Linking Excel cells to a Word document [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
> 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.
>
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> jada wrote:
> > 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....
>
>
>
Back to top
Doug Robbins - Word MVP
External


Since: Oct 18, 2005
Posts: 1386



PostPosted: Mon Nov 14, 2005 10:15 pm    Post subject: Re: Linking Excel cells to a Word document [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


--
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

"jada" wrote in message

> 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 believe 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...If 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
>> 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.
>>
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> jada wrote:
>> > 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....
>>
>>
>>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> MailMerge Fields All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum