topic Re: Macro settings error in QlikView

Macro settings error

Tue, 15 May 2012 17:05:21 GMT

I'm using a macro to copy reports from dashboard to excel sheet. For that i need to save settings for "Local security" as Allow system Access.

but the settings are not saving. When I save and use it from desktop its working. When I'm testing it from accesspoint its Showing error.

Macro settings error

m_woolf — Tue, 15 May 2012 17:22:37 GMT

When you test from the accesspoint, do shift+ctrl+M to see what the macro security level is.

Change it to System if needed and see if that resolves your problem.

Macro settings error

Tue, 15 May 2012 19:10:53 GMT

cant save change, after choosing " give system access to module script".

Macro settings error

m_woolf — Tue, 15 May 2012 19:28:01 GMT

Check out this thread:

http://community.qlik.com/message/146061#146061

Re: Macro settings error

Tue, 15 May 2012 19:53:54 GMT

already have that in place

this might be a stupid question or a very important point I missed. Does QV server need to have MS office(Excel) for me to use Macro?

Macro settings error

m_woolf — Tue, 15 May 2012 19:56:00 GMT

Only if you are running with the client installed on the server.

When accessing through the accesspoint, the macro is running on the user's PC.

Re: Macro settings error

Mon, 21 May 2012 15:35:46 GMT

We contacted the support team and sent them a copy of file with macro we are using. They tested it in QV 10 and 11 environments. Their expert openion was that....reason for failure is, its complete VBscript and we have to use API guide they have provided in the documententation to convert it into format that is supported.

Re: Macro settings error

Wed, 23 May 2012 14:32:01 GMT

did anyone use functions defined in API to achieve this functionality?

ie copying series of objects to excel sheet

Re: Macro settings error

m_woolf — Wed, 23 May 2012 14:35:42 GMT

Look at this:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/