I have a macro I wrote that executes 4 queries to an ODBC Database.
Each query runs on different table in the database but uses the same
search criteria. How can I pass the saved variables to the 4 queries
so the user doesn't have to enter them 4 times.

Thanks for the help

for each myvariable in mylist
=" & myvariable
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
I have a macro I wrote that executes 4 queries to an ODBC Database.
Each query runs on different table in the database but uses the same
search criteria. How can I pass the saved variables to the 4 queries
so the user doesn't have to enter them 4 times.

Thanks for the help

Use parameters in the queries, then have the parameters refer to the
cell(s) where the criteria have been entered.

Thanks!
Cliff Edwards

On Feb 6, 10:40*am, ward376 wrote:
Use parameters in the queries, then have the parameters refer to the
cell(s) where the criteria have been entered.

Thanks!
Cliff Edwards

So in the query on the criteria line I put a cell reference? I can
enter the values into a cell on the spreadsheet how do I have the
queries refer back to that cell when the macro is running?

Where are you querying from? (Access, as400 etc.) Are you using MS
Query?

If you can edit the SQL statement directly substitute a question mark
for an explicit value.

Cliff Edwards