Macro running does not end

[Anonymous]

I have a macro in a QV which does not stop running and the QV document freezes.  How do i end the running of the macro and what could be causing this?

[swuehl]

You can kill the QV.exe process, this should stop everything.

Hard to tell what causes the macro not to stop, without knowing the code, but maybe a loop in your code with a missing / incorrect exit?

[Chanty4u]

go to task manager and do end task of qvw.

[Anonymous]

Swuehl many thanks, this is what i have been doing, stopping the QV.exe. Attached is the qv app

[Anonymous]

Thank you for that

[sfatoux72]

There is not debug mode in macro editor, bur you could add msgbox('xxx')  if VBscript or alert('xxx') if Jscript to identify loop without end (invalid exit condition, ...)  or instruction waiting something, ...

[swuehl]

I wasn't able to spot an easy candidate causing the freeze.

But since you are calling R COM object methods, I would try to check if these method calls could be problematic.

Also there are some FOR .. NEXT loops that depend on returned values from the R object.

So, as suggested before, try to add more e.g. msgbox() statements to get an idea where in the script the freeze occurs, and maybe also to get an idea of the state of your macro code (i.e. the values of variables, return codes, etc.)

You should be able to use similar code (at least for debugging the R calls) in Visual Studio for debugging, if necessary.

[HirisH_V7]

Hi ,

I cant Open Your App,

Can you post the macro you are using !!

[Anonymous]

Many thanks Swuehl

[Anonymous]

Herewith macro