Orna,
I'm sure that there are several soluitions to your problem, but what I've done to solve the similar problem I had was the folowing:
In Access I create the query in VBA using CreateQueryDef. The VBA code allows me to insert formfields in the sql statement.
Now I can generate the excelsheet using the created query.
You could use the same technique, if the querynames are either passed to Excel or are known in advance.
I use access to generate everything; queries, VBA code to be inserted into a excelfile, starting of VBA code in excel...
Excel is just for reporting purposes.
EasyIT