98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Interrupting Macros
Interrupting Macros
Resolved · High Priority · Version 2010
Tue 16 Apr 2013, 15:44Delegate Sam said...
Sam has attended:
Excel VBA Intro Intermediate course
Interrupting Macros
Hi,
I wanted to check whether when a macro is interrupted (i.e. esc or control break is pressed) when the macro is then run again will the macro start from where it left off or start from the beginning of the macro?
Also, I have been having issues exceeding the internal memory of Excel when running a large model. Do you know of any problems which can occur when running macros when the internal memory is very nearly reached? (Running the model on the 64bit version of Excel 2010 seems fine, however I've reduced the size of the model and can run it in Excel 2007 but the macros seem to be doing strange things).
Sam
Wed 17 Apr 2013, 11:24Trainer Gary said...
RE: Interrupting Macros
Hi Sam
Thanks for getting in touch. If you interrupt a macro and then resume it then it usually continues from the same place. You can tell from the VBE by looking at the line highlighted in yellow - this will be the next line executed.
In larger models memory leaks can be exacerbated; these can be curtailed with very strict programming practice (declaring variables rigidly, closing routines etc) or having Excel the only process running on that machine. I recommend you search for "memory leak excel vba" for many suggestions on how you can diagnose these sorts of issues. The following link is a good start:
http://excel.tips.net/T002579_Getting_Big_Macros_to_Run.html
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Tue 23 Apr 2013: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Related tablesWhen you have related tables such as Customers and their Orders, the Customer table is the Primary table. |
