Data from Exel into Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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
Click to expand...
word replacing text that says A1?
 
Back
Top