topic Re: Problem running macro... in QlikView

Problem running macro...

Tue, 28 Aug 2012 16:02:09 GMT

Hi everybody..

I writed a small macro to sort a straight table in different ways, i also created a button with an action "run macro" to run the previous macro...

But the problem is, when i hit the button instead of run the macro the edit module dialog appears....

Im just beggining using macros and i suspect its a configuration issue because i already checked the macro and it had no errors....

Could you help me out?

Thanks in advance.

Re: Problem running macro...

Tue, 28 Aug 2012 16:04:15 GMT

Under Tools: Edit Module change your security settings to the following and see if it helps:

Re: Problem running macro...

Tue, 28 Aug 2012 16:10:27 GMT

YOu set into a module macro the OPTION "ACCESSO al sistema " "CONSENTI ACCESSO SISTEMA"(IN ITALIAN). iN ENGLISH I CAN'T TRADUCE. YOU CAN THE SECOND OPTION

Re: Problem running macro...

Tue, 28 Aug 2012 16:12:13 GMT

That translates to System Access > Allow System Access in English

Re: Problem running macro...

Tue, 28 Aug 2012 16:13:57 GMT

I did as you instructed me and still having the same problem... coul it be anything else?

Re: Problem running macro...

Tue, 28 Aug 2012 16:15:54 GMT

TH FILE IS LOAD IN A ACCESPOINT OR LOCAL ?

CAN YOU PASS ME A FILE ?

Re: Problem running macro...

Tue, 28 Aug 2012 16:16:03 GMT

Did you confirm that the name of the macro is identical to the name of the macro in the button action? Other than the macro itself containing an error, that's all I can think of. Marco, do you have any ideas?

Re: Problem running macro...

Tue, 28 Aug 2012 16:27:40 GMT

Yes its the same name, here are the screenshots:

(Of the macro)

()

And the button:

All the datasources are local(in hard drive) excel sheets since i'm developing the aplication in a laptop.

Re: Problem running macro...

Thu, 31 Oct 2013 08:16:21 GMT

Same happned to me, and I found that there was an error in my macro code. So fixed the error, and all worked fine.