Can i make the same change to seperate files

This may be a silly question but is there a quick way to make the same change to 50 different saved files. For example if i have got 50 seperate files of information and the writing colour is in black but i want to change the writing colour for all the seperate files to red, is there a quick way i can do this without having to go into all the seperate files?

Sorry for the poor example, hope it makes some sort of sense.......

hi,

put all your files into one folder except for this file that contains this macro
change the file path to suit
it will change all the text to red in sheet 1

Please Login or Register  to view this content.

hope this helps

steve

Apologies for being stupid but that does not mean anything to me......
If you could simplify please, much appreciated!!!

hi,

ok, put all the 50 files into one folder.
copy the macro into a new excel workbook and save that workbook in a different location to the other 50 files. chane the file path that is in the macro to suit your file path (IE where you have located your 50 files.
below was my file path when i tested the macro.

Please Login or Register  to view this content.

then run that macro

if you are still unsure come back to me

steve