G'day there One & All,

I'm currently trying to automate a reporting process at work where
data is derived from 3 separate spreadsheets. The 3 spreadsheets are the
results of a database query. After each spreadsheet has been loaded (and
each spreadsheet is a workbook with up to 20 or so pages), values such
as date, sales district, etc are set, and the data then refreshes.
Values are then copied manually from the required cells onto a Word
report which is then printed.

I'm in the process of building an XL document where the required
values are simply links to appropriate cells in the original 3
workbooks. I have a fair bit of it working fine (including some
calculated values which stretched my high school maths to the limit) but
I can't go further without writing code to search for & link to the
values I need. As part of that process I need to set the date & location
values from within my document. I'm sure I can do that, but whenever I
reset one of these values, the spreadsheets run an OLAP query and
recalculate the values. That's fine, they're supposed to, but since I
won't be updating the screen and will probably have the 3 workbooks
minimized, I need to know a method of finding out when the OLAP query
has finished and the calculations complete so I can continue with
"stuff".

Is there anyway I can monitor the progress of the queries to know
when to continue? I may even display a progress bar so my users won't be
left in the dark. Any assistance will be appreciated.

See ya later,
Ken McLennan
Qld, Australia