Hi all,
Let say that I have over 2000 old excel files in one folder. Each of these
excel files contain one macro and this is the same macro in all excel files.

I want to be able to create a script that will open each file one by one,
delete or overwrite the current macro by a new one.

All my code to open excel files is done and working. My problem is that I
don't know
how to retrieve the current macro once the file is open. Neither how to
overwrite it.

Any help will be greatly appreciated.

Christian