Changing ODBC Data Sources

[Román Valoria]

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.

 

[CLR]

If you wrote the Queries by recording a macro in Excel, then yes, you can
make global find and replace changes in VBA like you want...........but if
you created the Queries some other way, I dunno. This is one of the reasons
why I always create my MSQueries with the macro recorder turned on.

Vaya con Dios,
Chuck, CABGx3