topic Re: IE Plugin Macro in QlikView

IE Plugin Macro

Mon, 05 May 2014 13:08:03 GMT

Hi All

I have installed the IE Plugin for Windows 7, however when ticking the Macro Box cannot remember whether to allow Macros or not!

The issue is that when trying to Export to Excel no document appears. A colleagues Export to Excel function works seamless.

Please can someone assist on either trying to resolve the problem at hand, or to get the pop up screen again where you may select the correct Macro selection.

I have tried de-installing and re-installing but still to no joy.

Regards

Craig

Re: IE Plugin Macro

marcus_sommer — Mon, 05 May 2014 13:43:24 GMT

Macros depends from user-settings, perhaps you have clicked the wrong option ....

Go to C:\Users\YOURUSERNAME\AppData\Roaming\QlikTech\QlikView and change or remove the settings.ini - if you didn't have many customized settings removing is the easier way.

- Marcus

Re: IE Plugin Macro

Mon, 05 May 2014 13:50:06 GMT

Thanks Marcus

I have tried that as well from other threads and still am unable to enable Macros or Export to Excel?

Any other suggestions?

Regards

Craig

Re: IE Plugin Macro

fkeuroglian — Mon, 05 May 2014 13:53:13 GMT

Hi, try to attach and example to see what happend

Fernando

Re: IE Plugin Macro

Mon, 05 May 2014 14:00:54 GMT

Hi, I am not sure what to attach as nothing can be exported. Every selection spins the think icon and then results back to the std pointing icon.

It is as if the data is being gathered by the machine then no execution to opening program?

Regards

Craig Martin

Re: IE Plugin Macro

jerrysvensson — Mon, 05 May 2014 14:06:44 GMT

Re: How to Get Rid of Module Security Dialog Box when Exporting to Excel

As far as I know, the 'Give System Access to Module Script' IE Plugin option is stored in a Settings.ini file located at C:\Users\username\AppData\Roaming\QlikTech\QlikView (Win7 folder) in the client machine. When you open the file, there should have a piece of code like:

[Settings for QlikView Servers]

Module Script System\servername1=

Module Script System\servername2=

Module Script System\servername3=

Re: IE Plugin Macro

marcus_sommer — Mon, 05 May 2014 14:07:30 GMT

Export-macros to excel require the proper access/security rights - could you export to excel manually, have you access to the target file-directory, run simply macros like msgbox "Hello World"?

- Marcus

Re: IE Plugin Macro

Mon, 05 May 2014 14:16:30 GMT

I have the appropriate access rights – as my profile on my colleagues machine allows to export.

On my machine is seems to have embedded not to export.

Regards

Craig Martin

Re: IE Plugin Macro

Mon, 05 May 2014 14:18:54 GMT

Thanks, all I get is this:

ExamplesFolder=Examples

InstalledLIBID110={some long code}

InterfaceLanguage=English

Re: IE Plugin Macro

marcus_sommer — Mon, 05 May 2014 14:21:25 GMT

Not all settings are within the user-profil, have you tried my suggestions on your local machine?

- Marcus

Re: IE Plugin Macro

jerrysvensson — Mon, 05 May 2014 14:22:38 GMT

This is on client side.

If you are missing this tag, you can just add it:

[Settings for QlikView Servers]

Module Script System\servername1=

Re: IE Plugin Macro

Mon, 05 May 2014 14:30:18 GMT

Excuse the ignorance but what is “run simply macros like msgbox "Hello World"?”

Re: IE Plugin Macro

marcus_sommer — Mon, 05 May 2014 14:36:09 GMT

It is only the check if any macros are executed or not - if not it isn't a export issue.