Copying data from Excel to MS Word

I have numerous single-sheet Excel files (all of which are the sameformat), from which I need to copy the data into a MS Word Templatealugning specific cells in the spreadsheet to specific fields in theWord document.Can anyone help ?

Share:

4 Answers Found

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

It is then just a question ofOpen the excel workbookOpen the new word docstep through the bookmarks in the doccopy the content of the relevant excel cellpaste to the relevant bookmarksave the docclose the workbookGo on to the next workbook