topic Re: Executing Macro in qlikview in QlikView

Executing Macro in qlikview

Mon, 28 Apr 2014 12:17:42 GMT

Hi,

Have an annoying problem in Qlikview. I am not able to execute any Macro. when i press a button that is set to execute a Macro it will show the Macro Code, not execute the macro.

I have done the following to try to solve this particular problem:

*Checked security settings for macro

*Checked settings in macro script

*Checked settings in Sheet/User/Document properties.

*Reïnstall Qlikview completely.

Do you have any suggestions as to what it could be?

Re: Executing Macro in qlikview

bbi_mba_76 — Mon, 28 Apr 2014 12:23:17 GMT

Hi,

I suppose you have tried to run a macro from different qvws.

Which version do you have? what about the OS? only qlik is affected?

could you try with another pc?

Re: Executing Macro in qlikview

NareshGuntur — Mon, 28 Apr 2014 12:23:19 GMT

Hi,

Does the macro code works fine when you test run it in macro window?

Cheers,

Naresh

Re: Executing Macro in qlikview

Mon, 28 Apr 2014 12:26:59 GMT

Yes I have tested macro's form different QVW's, my colleague is able to execute the macro's. So they work.

Version: 11.20.12235.0 SR5 64bit

OS: Win 8.1

I am able to execute Macro's in excel.

Re: Executing Macro in qlikview

Mon, 28 Apr 2014 12:27:10 GMT

Yes it checks fine

Re: Executing Macro in qlikview

PradeepReddy — Mon, 28 Apr 2014 12:29:58 GMT

There might be some mismatches in naming conventions...

Please check the settings in Macro window...

If possible, can you please upload the doc..?

Re: Re: Executing Macro in qlikview

Mon, 28 Apr 2014 12:35:55 GMT

Of course, I have to mention probably. I do not have Excel on my computer, i use Open Office.

this is just a sample for Macro which exports to Excel, QLikview normally exports it directly using the XL button to Open Office.

Re: Re: Re: Executing Macro in qlikview

Mon, 28 Apr 2014 12:40:07 GMT

Strange i tested this macro(see attachment) and this seems to be working

Re: Executing Macro in qlikview

PradeepReddy — Mon, 28 Apr 2014 12:56:26 GMT

Pls change the macro settings...

Current Local Security --> Allow System access

I have executed successfully after doing the changes.

Thansk,

Pradeep

Re: Executing Macro in qlikview

jerrysvensson — Mon, 28 Apr 2014 12:56:33 GMT

Can you give us your macrocode?

It will be easier to find the problem then.

Re: Executing Macro in qlikview

PradeepReddy — Mon, 28 Apr 2014 12:59:36 GMT

Hi Herry,

No problem in Macro.. Macro is working fine....

If we set the bellow option in Macro window.. it is working fine.

Current Local Security --> Allow System access

Re: Executing Macro in qlikview

PradeepReddy — Wed, 30 Apr 2014 17:40:15 GMT

Hi narad,

If you get the solution, mark the answer as correct..so that it will be helpful for others.

Thanks,

Pradeep

Re: Executing Macro in qlikview

Ronnie_Taborn — Thu, 01 May 2014 01:29:59 GMT

http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/28/macros-are-bad

Re: Executing Macro in qlikview

Tue, 06 May 2014 15:00:39 GMT

Found the solution, or the cause of my problem, looks like it was because i did not have office installed.