View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default Use VBA to Enter Break-Mode?

On Wed, 23 Jul 2008 11:26:01 -0700, RayportingMonkey
wrote:

I played with setting up a watch that breaks the script if a file named
pause.excel appears at a specific location - this did allow me to force the
code to enter break mode on a remote computer by creating the file
pause.excel from my laptop.


That's pretty clever.

You might sprinkle some DoEvents lines in your code, particularly in loops.
This will allow commands in the Windows stack to execute and may be enough
to give you access and allow Control-Break to work.
--
Dick