CODEWITHSUNDEEP
vbaexcelvbscript
DARKOCEAN
DARKOCEAN

Reputation: 109

VBA Randomly Stops Running Macro

Two large VBA Projects that execute every hour of every day. They usually take 55 minutes to complete. They have been working perfectly for the past month or so.

All of a sudden, in the early hours of the morning, VBA suddenly stops executing the code at random points.

The files are opened via VBScript. When it fails, the VBScript is still running, waiting for the Macro to complete. I'm unable to control Excel and I can't open VBA to see where it has got stuck. I can't easily post the code as there is simply too much.

Any tips of things to try to get it working again? This is running on Windows Server 2012 R2.

I've tried restarting the server and I've also tried a Code Cleaner.

Upvotes: 0

Views: 2430

Answers (1)

SlowLearner
SlowLearner

Reputation: 3294

This is not uncommon, it seems to happen after a debugging session and for one reason or another BreakPoints are not properly cleared. Solution is:

Press Ctrl+Pause|Break twice.

Credit:

@Stan https://stackoverflow.com/a/5823507/3451115

Upvotes: 4

Related Questions