ODBC DSN

[Paul]

When I create an Excel 97 Spreadsheet with data extracted
by using MS Query, it has problem in running on another
person's machine.

I believe that it is because the ODBC DSN has not been
properly created on that machine.

However, when I open my spreadsheet again, I have no way
to find out which ODBC DSN is used as it is password
saved. Is there any way for me to find out which ODBC DSN
is used ?

Thanks

 

[Roadie]

You can record editing the query in a macro. After finishing, you can
find the information about ODBC-driver, userid, password, server etc.
in VBA. However, there's no information about DSN-files used.
But my experience is that problems in exchanging/sharing files with
ODBC-connections are not caused by DSN-files, but by the wrong version
of the ODBC.