I use the shell command to launch an access project file.
I need to detect when this process(Access) has terminated (a macro
within the access project file terminates itself once it has finished
what it is doing).

The reason for ths is that I want the Access Project to run and do its
thing;
Excel code waits until the process has finished;
Excel (using VBA) refreshes pivot table.

Can anyone help me on this or is it beyond the scope of VBA ?



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