LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default Use VBA to Enter Break-Mode?

I run a lot of code on a remote computer. The problem is that sometimes the
code hangs up, or the job runs longer than anticipated and I need to break
the code. unfortunately, sometimes I can't even remote into the machine or
Ctrl-Break isn't recognized.

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.

I haven't played with the watch feature until now so to test it I savd the
file, launched from another computer and looked at the watch, but it was
empty.

Is there VBA that I can put in the On-open statement that would Add my
critera for a Watch?

Or is there another way to force Excel into break-mode from a remote computer?
--
"Trying to make reports so easy... even a monkey could run ''em!"
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't enter break mode at this time ERROR Ayo Excel Discussion (Misc queries) 4 July 21st 08 05:09 PM
can't enter break mode at this time DanR Excel Programming 7 May 7th 07 02:53 PM
Can't enter break mode at this time CWillis Excel Discussion (Misc queries) 2 June 1st 06 07:43 PM
Can't enter break mode eugene Excel Programming 0 May 11th 06 09:21 PM
received message: Can't enter break mode at this time William Weder Excel Programming 0 March 1st 06 01:58 AM


All times are GMT +1. The time now is 05:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"