I've already visited these sites and they are very helpful. But in this case,
this customer want an external solution to manage his excel files because it
was a one
shot deal.

So I've built a vbscript in an hta to do this.
But thank's for your suggestion I appreciate.

"Norman Jones" wrote:

Hi Chris,

To cycle through the files, see VBA help on the Dir function or adapt Ron de
Bruin's sample code at:

http://www.rondebruin.nl/copy3.htm

To delete, amend or insert code, see Chip Pearson's page on programming to
the VBE at:

http://www.cpearson.com/excel/vbe.htm

I would suggest, however, that rather than replacing the existing code in
each of the 2000 workbooks, you should consider creating a single Addin and
making the Addin available to all appropriate users.

In this way, future editing could be limited to a single file,


---
Regards,
Norman



"ChrisSaw" wrote in message
...
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