interrupting macros

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Interrupting Macros

Interrupting Macros

resolvedResolved · High Priority · Version 2010

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

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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Related tables

When you have related tables such as Customers and their Orders, the Customer table is the Primary table.

Open the Customers table in datasheet view and go to the Home Tab and Records group. Click on the More option and choose Subdatasheet and then click on Subdatasheet again. Now choose the related table (Orders) and click ok.

Now you can click the + symbol by each company to show the related orders.

View all Access hints and tips


Server loaded in 0.12 secs.