Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from Exel into Word
How can I create a macro that takes data from exel into word
For Example take the content of cell A1 in mylist.xls and place it into word replacing text that says A1 Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data from Exel into Word
Hi, Jere. This would probably be automated easier from Word code than Excel
code. You'd want to set a bookmark in your Word document where you want the value to show. Then a Word macro would open the Excel file, grab the value of A2 from the correct sheet and put it in a string, and set the contents of the bookmark as that string. Does this work for you? HTH Ed "Jere" wrote in message ... How can I create a macro that takes data from exel into word? For Example take the content of cell A1 in mylist.xls and place it into word replacing text that says A1? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create hyperlink from exel file to particular word in word file | Excel Discussion (Misc queries) | |||
Data Sort #ERR in copied data - Exel 2003 | Excel Discussion (Misc queries) | |||
How do I transfer information from Exel to Word Mailings? | Excel Discussion (Misc queries) | |||
MY EXEL/WORD OFFICE 2000 IS RUNNING VERY SLOW AFTER DOWNLOADING U. | Excel Discussion (Misc queries) | |||
Replacing instances in word with data from exel | Excel Programming |