Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

interrupting macros

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

Interrupting Macros

ResolvedVersion 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:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.



Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.



To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.



Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.



However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.



View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.