"GarethG" wrote in message
...
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 ?


Far from it but you would be better off using automation via
VBA instead of the shell command

http://www.microsoft.com/OfficeDev/Resources/Auto97.htm
http://support.microsoft.com/default.aspx?kbid=260410

Keith