All:

I have an Excel 2002 workbook with a lot of sheets. Each of those connect to
a table in a specific access 2000 database. I had to recreate the access
database due to a hole in the security. I had to create a new workgroup file
and a new .mdb.

I have used the same name for the .mdb file, but a different one for the
.mdw file (it had a typo in it).

Useless to say that now none of the sheets is refreshing the data and to
manually change all of them is a mess.

Is there any way I could change the reference to this new .mdw and .mdb file
in order to avoid doing the queries again one by one?

Any VBA code I could run from Excel to update all references from .mdw1 and
.mdb1 to .mdw2 and .mdb2?

Thanks in advance,

Roman.