Hi Robert,

There is no way of knowing when the queries are finished

You can use AfterRefresh event for your query. For that you have to use
class module. For more details and example see VBA Help for "Using
Events with the QueryTable Object."


Regards,
Shah Shailesh
http://members.lycos.co.uk/shahweb/


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!