LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default VBA code mysteriously stops running

Hello all,

I've got some VBA code in an Excel 2003 file that opens up other Excel
files, updates links, runs some macros, and generates a new Excel file for
output.

This code has been thoroughly tested and 95% of the time it runs without
problems. However, every now and then the whole routine just stops running.
It never generates an error and I can't find anything wrong in the code. Most
times if I close everything and start over, it will run all the way through
with no problems.

While this code runs, I'm often doing other things (checkin e-mail in Lotus
Notes, or using Internet Explorer or Access). I believe, but I'm not certain,
that somewhere along the line, I hit some keystroke combination that causes
my Excel VBA to choke. I never have this problem if I don't use any other
programs and just sit back and let it run. However, that's not a great use of
my time.

Does anyone know of any verboten key combinations that could break VBA? Or
something else I could be doing to cause the code to stop?
--
Hmm...they have the Internet on COMPUTERS now!
 
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
Code Stops Running Instead of Debugging [email protected] Excel Discussion (Misc queries) 1 December 10th 08 07:15 PM
Instead of debugging, code just stops running [email protected] Excel Discussion (Misc queries) 1 August 13th 08 07:26 PM
why excel stops running?? usiddiqi Excel Discussion (Misc queries) 2 May 17th 06 10:14 AM
Mysteriously terminating code [email protected] Excel Programming 6 August 2nd 05 03:22 PM
Running Code looses focus to Outlook and stops Steven Kelder Excel Programming 0 January 2nd 04 07:59 AM


All times are GMT +1. The time now is 01:01 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"