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?