Change a lot of data - new Excel's user

[BoKo1]

Welcome!
I have to change a lot of data that can be found on more than 1,000 sheets and each sheet is in another file. More specifically - I have to change the record 5E78340B on record 5E78320B. I know that I have to use the MACRO but it's very complicated and I'm new to Excel. Does anyone could use some help?

[simcode]

Hi
I'm not sure if the file is you want. if it is, remember adding my reputation, pls.

[BoKo1]

I want to be sure.
Can I change DIRECTORY?

I open new catalog on the drive F:\Samples
and inside I have 5 different files with 5 different Excel sheets with data


I tried. I changed directory - F:\Sample\ and I checked files - nothing changed
I did it again with new directory - F:\Sample\File 1\ - nothing changed
In my job I use Excel 2003
Drive F: is my USB memory

[simcode]

Hi, BoKo
Yes, you can change DIRECTORY, and it doesn't matter files are saved in hard disc or USB memory. If the codes does not run, you'd better check Macro Safty of you excel, confirming that Macros are enabled.

[BoKo1]

Hi Simcode!
I did it again and still same problem - nothing changed. I checked my excel (Security Warning - Enable Macros), I checked Tools - Macro - Security (Medium).
After that I choose Directory - F:\Samp\ and click Go

Maybe problem is with my catalogs?
F:\Samp\File 1\Samp 1.xls
F:\Samp\File 2\Samp 2.xls
F:\Samp\File 3\Samp 3.xls
F:\Samp\File 4\Samp 4.xls
F:\Samp\File 5\Samp 5.xls

[simcode]

i know, the files were saved in subdir.

[BoKo1]

Thanks for your help.
And sorry - on my computer it doesn't work. Nothing changed.
I don't know - maybe I do something wrong?
I am not advanced user of Excel.

[simcode]

Macro Security, set to Enable all

[BoKo1]

Thanks again.
I still have a problem, I don't see any change after I use GO button.
I tried to do it on my work computer (Excel 2003) and home computer (Excel 2010)

I will be try to fix my excels sheets manually )