SUZUKI

"Bill Martin -- (Remove NOSPAM from addre" wrote:
Can you just try to open the output file, and if an error is detected loop back
and try again ... and again? Maybe wait 1 second first before starting the looping?
Bill

Thanks a lot.
I am very glad to know very simple and easy method presented by you.
This method, however, may consume CPU resource, and errors of too many
times may cause some trouble.
Is there more elegant and safe way to let VBA program idle until
Ap1.exe terminates.

SUZUKI Wrote:
SUZUKI
Thanks a lot.
I am very glad to know very simple and easy method presented by you.
This method, however, may consume CPU resource, and errors of too many
times may cause some trouble.
Is there more elegant and safe way to let VBA program idle until
Ap1.exe terminates.

This would require using API functions to make a snapshot and AP
process functions
you can find information on: URL: 'API page' (http://www.allapi.net/

--
Dnere
-----------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...fo&userid=2618
View this thread: http://www.excelforum.com/showthread.php?threadid=39609

Thanks a lot for infomation on API.
Now, I underatand that I should learn API.
--
SUZUKI