Good morning (it is here -and cold too!)
I am working on a project whereby an Access database is updated on a
daily basis. A Pivot Table displays the information as required and my
boss is happy, and I don't get nagged for the information every morning
;)

I have most of the project set up, except the automated side. I was
thinking of implementing the following solution and am basically
looking for an alternative method(my solution seems a little untidy).

When the Excel document opens my macro executes the Access query which
refreshes the database.
Once Access has refreshed the database it executes a macro within Excel
to refresh the pivot table.
Access then closes.
Pivot Table is refreshed, boss is happy :)

I am concerned that this "handshaking" between the two applications may
cause some problems (which I have not forseen).
My main concern is that Excel has a macro running which is interacting
with Access and Access is then in turn interacting with Excel.
Is there a way in which Excel is aware of the "progress" of the Access
query? So that Excel itself is able to refresh the pivot table rather
than relying on Access to execute this command?

Another small issue (but not my main concern) is that when Access is
called from Excel is it possible to "hide" Access from the user so that
it does not appear in the task bar?

Appreciate any help
Appologies for any spelling errors



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/