The ODBC connections i a workbook are the queries you created. the
appear in the workbook names. So you can search through the names.
Youcan see the named in one of two palces

1) Insert Name define
2) File Property custom


You can also find all the queries in a workbook and then look at the
conenction property.

for each sht in sheets
for each qry in sht.queries


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=173403

Microsoft Office Help