Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Frankie Adams   on Jan 11 In MS Office Category.

  
Question Answered By: Cais Nguyen   on Jan 11


You have 2 ways to go about it. Either in excel  or in Word. Either way you
will need references checked for both excel and word.
The macro will need to be in a separate workbook, not one of the ones to be
extracted from
Presumably you have bookmarks in the word  doc?

It is then just a question of
Open the excel workbook
Open the new word doc
step through the bookmarks in the doc
copy the content of the relevant excel cell
paste to the relevant bookmark
save the doc
close the workbook
Go on to the next workbook

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Copying data from Excel to MS Word Or get search suggestion and latest updates.


Tagged: