Problem with running macro send to excel

[eliran]

Hi all,

I've got a problem, I made a few macros in order to send reports to excel.

The macro is working great, but the problem is, once the user clicks the button, the macro window is popping out and the user needs to click "allow System Access" under "current local settings".

Obviously I can't let that happen, how can I fix it? Am I missing something in the settings?

Regards,

Eliran.

[jonathandienst]

Eliran

I think it is the Macro Override Security option on the Security tab of the document properties. Also ensure that you select "Allow system access" on the module itself.

Jonathan

[suniljain]

in security tab of setup in QEMC ,

select Qlikview server . in right side window

check 'allow Macro execution on server"

[eliran]

Hey Jonathan

This is exactly what I did.

I changed these settings and saved the document.

But after opening it back again and trying to activate the macro I keep getting the same macro window.

It's not saving the "allow system access. and I don't know why.

Eliran.

[eliran]

Sunil Thanks,

But I should have mention that This customer doesn't run a server, So that's not the answer to my problem.

Thanks non the less for trying,

Eliran.