Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
renaudfeuvrier
Partner - Contributor II
Partner - Contributor II

Impossible to open Excel with a JS Macro

Hello,

I'm using QV 11.20.12904.

I 've got a problem with a JS Macro.

I link a button with a JS macro. It tried to create an Excel.Application object and failed (var XLApp = new ActiveXObject("Excel.Application")). When I try to open an Excel Application by using a JS Macro, I received the following message : "Un composant ActiveX ne peut pas créer un objet" ( an ActiveX component can not create an object).

Is there a spécial system requirement to autorise QV to create an Excel application ?

2 Replies
Gysbert_Wassenaar

Check the security settings in the Module Editor. You may have to enable System Access and Allow System Access.


talk is cheap, supply exceeds demand
renaudfeuvrier
Partner - Contributor II
Partner - Contributor II
Author

The both are already enable.

It's look like the error is coming from the Windows OS settings.