The nice thing about SQL.REQUEST is that you can structure it to use
replacable filenames parameters (the "missing" feature of INDIRECT), and you
can also run UPDATE queries which will update data in closed Excel files.

The downside is that it's slow.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"Patrick Molloy" wrote in message
...
Thanks - never used it. Recent MS updates have raised some issues with
OLEDB. We use ADO exclusively now...which my code also uses.
We found that an update about 2 weeks ago caused our pivot tables (
default
to OLEDB) were taking up to 45 minutes to refresh 300,000 rows from our
databases. Setting the pivot cash instead to an ADODB recordset got us
back
to <2 minutes.

--
Patrick Molloy
Microsoft Excel MVP
---------------------------------
"Andy Wiggins" wrote in message
...
Upto and including Excel 2002 SQL.REQUEST has been part of the XLODBC
addin
supplied by Uncle Bill.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"Patrick Molloy" wrote in message
...
This is not a standard Excel function - it looks like
sombody made one for you.