G
Guest
I have written an excel spreadsheet that uses many query's to get info from
an Access db. In some cases, a query uses the results from another query as
parameters. I have set up a macro that refreshes each table separately using
a For...Next loop to refresh each Querytable within each sheet. My thought
was that by running the queries in order, the results would be back on the
first queries before the second queries run. In each case, the spreadsheets
do not update until all the query defs run. I have tried putting a wait
command in and turning on and off screen updating. I am hoping to avoid
using the "Update query when Cell changes" option. Any thoughts?
an Access db. In some cases, a query uses the results from another query as
parameters. I have set up a macro that refreshes each table separately using
a For...Next loop to refresh each Querytable within each sheet. My thought
was that by running the queries in order, the results would be back on the
first queries before the second queries run. In each case, the spreadsheets
do not update until all the query defs run. I have tried putting a wait
command in and turning on and off screen updating. I am hoping to avoid
using the "Update query when Cell changes" option. Any thoughts?