Hi,

Right now I have a collection of Excel spreadsheets that access an
Access 2003 database via individual Access queries where Field1 criteria
is unique for each query. What I would like to do is replace all the
individual queries with one query with a field1 parameter that I can can
change in VBA code then run the query so that the Excel spreadsheet data
is dynamically updated. Can this be done? If anyone can prove an
example of a VBA program executing an Access 2003 query after specifying
a criteria value to update an excel spreadsheet's external data range I
would find this most helpful.

TIA,
Dan