Script.js Error - Automation Server Can't create Object

[#1]

Hi

I have created an extension object, using the Script.js for the extension I want to generate an excel file on basis of selection done.

But I get error "Automation Server Can't create Object error" on the following line -

var xls = new ActiveXObject("Excel.Application").

Has anyone faced similar issue and know a solution for it? or any other tip to accomplish the requirement.

[danielrozental]

There could be several reasons for this, most probably a security setting in your IE. You shoud try to google the error as there are several resources around like

http://social.msdn.microsoft.com/Forums/en/netfxjscript/thread/3a3f7161-3581-47d1-a79c-98c0351ece38

http://forums.asp.net/t/1440442.aspx/1

http://www.aras.com/Community/forums/p/2527/7700.aspx

[#3]

Hi

My IE security settings are set as required. My code works fine on IE when used outside of QlikView Script.js.

I get this error only when I run it within Qlikview using extension object.

Also, have set system access on my macro settings. But the issue is only when I run from within QlikView.

Thanks