Multiple workbooks, one task
 

Please help to solve a puzzle!
I have excel file (workbook.1) with column A (old
variables names) and column E (new variables names). On the other hand I got
40 excel files (workbook.2 .... .40), where those old variables names used
here
and there, sometimes in a middle of the text. The goal is to replace all old
variables with the new ones. Exp.: if A5 has a match, replace with E5, and
etc.

Multiple workbooks, one task
 

Where are the 40 files ? in the same folder ? Are all the files of this
folder to be treated ?
Regards.
Daniel

Please help to solve a puzzle!
I have excel file (workbook.1) with column A (old
variables names) and column E (new variables names). On the other hand I got
40 excel files (workbook.2 .... .40), where those old variables names used
here
and there, sometimes in a middle of the text. The goal is to replace all old
variables with the new ones. Exp.: if A5 has a match, replace with E5, and
etc.