I've just taken over a project that was recently moved to production, with errors. One of them, is that the xls spreadsheet on click of a button (has macros) brings up a connection window, with the address being that of the test server. The quick fix is that users enter the correct ip address. .. but on the test server they never had to do this, as it was build into the connection string.

For the life of me, I cannot find the connection string, no matter where I seem to look in the vb editor. . .please please please, can someone point me in the right direction?

  I've never really done anything like this in Excel, but have you tried looking at the onclick event and see if it's referencing a cell? There could be a hidden spreadsheet with the values on it, in this case you'd click Window >> Unhide. Also they could have it hidden in a macro that's password protected and you just can't get to it without a 3rd party software to get password.

Hope this was some help.

If you know the excel sheet name, you should be searching for it in your code, that should help you locating the connection string.
Hope that helps.

cheer.

_________________________
- Vijay G
Strive for Perfection