Changing field links in multiple word documents from one excel file to another

[yondor]

Hello,

I have multiple word files (word 1, word 2, etc.) which take data from one excel file (excel 1). These files are essentially templates, which I would like to be able to copy to a new folder, and then change data in the excel file to result in word files with the new data.

I have successfully used the code in post 8 in the following thread (thanks macropod!) to update field links in one of the word documents to the new excel file:
https://www.msofficeforums.com/word-...one-excel.html



I would like to ask if there is a way that I can cycle through all my word documents to process them all at once with this code?

Also, is it possible to change the name of the word documents to include information from the excel file before saving? e.g. "word 1 'B2'.docx", "word 2 'B3'.docx", where B2 and B3 will contain the writing from the corresponding excel cells.

Many thanks in advance!