Catch quit macro event?

[notuserfriendly]

Hi I'm trying to find out why my macros work great while working in Excel only and why they stop when working in other applications. Would like to know if there's a way to see if ESC is sent to Excel when not having the program active. Some operations take a lot of time and I would like to be able to use other programs. Any ideas?

/I

 

[TonyJollans]

Hi notuserfriendly,

I'm not entirely sure I understand the question, but if you are asking if macros continue to run in the background when you switch to another application, then the answer is yes, they should.

If that is the wrong, or an insuficient, answer then please post back with some more information about what you are trying to do and what doesn't work, or appears or doesn't appear to happen.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[notuserfriendly]

Ok the thing is I'm working with other applications while waiting for my macros to run the sometimes quit.And it only happens when I'm working in the other applications (IE, MSN and remote Desktop). It's the same behaviour as when using ESC when running a macro.

What I'm doing is opening files and searching for information in them, writing stuff down to sheets.
Will change the reading from file and read into memory.
But want to know why it sometimes work and sometimes not.

/I

 

[TonyJollans]

Hi notuserfriendly,

Not sure what happens pressing ESC (nothing at all for me) but nothing I know leads me to believe that running other applications should have any effect on running macros unless you are interfacing with other apps within your code.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[notuserfriendly]

ok, strange, because when I make it during my macro that takes like 5 seconds per row, If one has like 600 rows it interrupts the function or sub running.

/I