Hi everyone - I just remembered that the Internet is my friend and found this handy statement on MSDN:
APPLICATION.OLERequestPendingTimeout = 0 It seems to solve this problem. ---------- Forwarded message ---------- From: Devon McCormick <[email protected]> Date: Thu, May 5, 2011 at 4:53 PM Subject: More Excel/OLE difficulties To: J-programming forum <[email protected]> Hi All - I've run into another annoying problem attempting to use J to drive a process in an Excel spreadsheet. Some of the processes take several minutes and this seems to trigger a dialog box which tells me This action cannot be completed because the other program is busy. Choose 'Switch To' to activate the busy program and correct the problem. This legitimately occurs when the Excel workbook has a dialog box up and is waiting for input. However, it also seems to occur just when the process I'm calling takes more than about ten seconds to complete. Has anyone else run into this? Any ideas on how to avoid this box completely or dismiss it programmatically? Thanks, Devon -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail -- Devon McCormick, CFA ^me^ at acm. org is my preferred e-mail ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
