Hi there,

I have an Excel file 2002 format that currently has a
query extracting data from a mainframe file using an ODBC
Connection. All works fine. Now time to progress to the
next level, and have some parameters, to limit the data
coming from the mainframe file.

I have a field on a sheet called "tables" that contains a
department code "001".

Q1. How do I limit the ODBC connection to obtaining only
those records with the department code "001", without
hard coding that into the query (the department may
change).

Q2. How can I programatically create an ODBC connection
to the mainframe table without having to configure the
ODBC driver on each user's PC ?

Thanks in advance.