How do you know when a data refresh is complete
 

I have an Excel worksheet which is opened from a Access
2002 project vba module. The worksheet has several
MSQUERY queries which are triggered by the Access project
writing to particular cells. After writing to the Excel
cells the Access application tries to 'save as' the
worksheet. Unfortanetly Access is requesting the 'save
as' whilst the data refreshes are ongoing.

My question: is there a way of interrogating Excel to find
out if a data refresh is outstanding?

Thanks in advance.

David.

How do you know when a data refresh is complete
 

QueryTable objects have a boolean "Refreshing" property that returns the status if the query is setup as a background query. You could also (I believe) just turn off the Background query option on all queries, or perhaps just the last query

-Bra

----- David wrote: ----

I have an Excel worksheet which is opened from a Access
2002 project vba module. The worksheet has several
MSQUERY queries which are triggered by the Access project
writing to particular cells. After writing to the Excel
cells the Access application tries to 'save as' the
worksheet. Unfortanetly Access is requesting the 'save
as' whilst the data refreshes are ongoing.

My question: is there a way of interrogating Excel to find
out if a data refresh is outstanding

Thanks in advance

David.

How do you know when a data refresh is complete
 

This sounds like a case of 'spot where the *real* problem lies'.
Solve the problem, don't just treat the symptoms.

Your approach sounds a mess IMHO. MS Query is a client (Excel) side
data access technology but you are also using the server (MS Access
automation - not even using Jet!) to directly write data to the
client. I'd suggest you use one or the other. Sounds like your
workbook is static and your data is dynamic so I suggest you just use
Excel for the clever stuff and use Jet as a dumb data store.

Feel free to post back if you need advice on changing your data access
approach.

--

"David" wrote in message ...
I have an Excel worksheet which is opened from a Access
2002 project vba module. The worksheet has several
MSQUERY queries which are triggered by the Access project
writing to particular cells. After writing to the Excel
cells the Access application tries to 'save as' the
worksheet. Unfortanetly Access is requesting the 'save
as' whilst the data refreshes are ongoing.

My question: is there a way of interrogating Excel to find
out if a data refresh is outstanding?

Thanks in advance.

David.