Excel: Code To Open Files Within Folder Make Changes And Close


I need a code that will open dozens of files within a folder in my desktop and if what is found in column A in the active sheet in column AG in each file then it needs to be changed to what is in column B as below. Thanks Excel 2010

A B
1 Column AG Changes To
2 Centre Centre
3 Centre-LH LH Centre
4 Centre-RH RH Centre
5 FR FR
6 FR Inner-LH FR LH Inner
7 FR Inner-RH FR RH Inner
8 FR Lower-LH FR LH Lower
9 FR Lower-RH FR RH Lower
10 FR Outer-LH FR LH Outer
11 FR Outer-RH FR RH Outer
12 FR Upper FR Upper
13 FR Upper-LH FR LH Upper
14 FR Upper-RH FR RH Upper
15 FR-DS FR DS
16 FR-Inner FR Inner
17 FR-LH FR LH
18 FR-Outer FR Outer
19 FR-PS FR PS
20 FR-RH FR RH
21 Inner Inner
22 Inner-LH LH Inner
23 Inner-RH RH Inner
24 LH LH
25 Outer Outer
26 Outer-LH LH Outer
27 Outer-RH RH Outer
28 RH RH
29 RR RR
30 RR Inner-LH RR LH Inner
31 RR Inner-RH RR RH Inner
32 RR LH+RH RR LH+RH
33 RR-Inner RR Inner
34 RR-LH RR LH
35 RR-Outer RR Outer
36 RR-RH RR RH
[CENTER]Sheet1[/CENTER] So looking at row 3 if Centre-LH is found in column AG of any of the files then it needs to change it to LH Centre, save and close each file and so on...


This question generated 25 answers. To proceed to the answers, click here.

This thread is current as of July 25, 2014.


For more resources for Microsoft Excel