Hello all

My company is moving the business system from one server to another
one so we need to change the ODBC data source for all the reports. The
reports were created using MS Excel 2003. My task is to change every
single report (there are a lot of reports). Right now what I am doing
is manually changing the ODBC by opening the report and
ToolsMacrosMS Script Editor then I find the DNS=name of ODBC driver;
DB=name of DB, etc. This is taking me forever for each report since
there are multiple worksheet in each excel report file.

My question: Is there any way I can create a script to automatically
change the ODBC data source from the old server to the new server? or
maybe another faster way to do this?

Thanks in advance