topic Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE in QlikView

ActiveX component can't create object: 'Excel.Application' error on IE

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have a macro which has the following line:

set XlApp = CreateObject("Excel.Application")

The macro works fine when I tested on my local QV 32 bit. I'm able to copy and paste the object I wanted to Excel after clicking the button

However, when I deploy this to the server which uses 64 bit QV, I'm getting the following error when I access the report through AccessPoint:

Macro parse failed. Functionality was lost.

SendToXL_8_1_1

Error: ActiveX component can't create object: 'Excel.Application'

Please help... Is it because the QV in the server is 64 bit? Is this possible?

ActiveX component can't create object: 'Excel.Application' error on IE

Wed, 23 Jun 2010 12:55:13 GMT

Hi,

you must allow system access.In your macro modul at right down of screen you shoud choose allow system access.

(Sorry for bad English)

ActiveX component can't create object: 'Excel.Application' error on IE

Wed, 23 Jun 2010 13:00:20 GMT

HI,

If you have allready do this in yous macro modul so that can hapend because you didn't allow macro to override security in Parameters --> document preferences

AW:ActiveX component can't create object: 'Excel.Application' error on IE

biester — Wed, 23 Jun 2010 13:40:13 GMT

Don't know whether AJAX is envolved here, but when calling the macro from the access point with Ajax, I suppose it's being executed on the server, NOT on the client. And even if Excel were installed on the server, it would be executed there (you would have a process on the QlikViewServer under the user who's running the qvs.exe. You can check what's happening with e.g. procmon and task manager.

Rgds,
Joachim

Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

Wed, 23 Jun 2010 13:49:27 GMT

It's evident that it will be executed on the server. but if you don't allow macro to override security and to access to system that won't not be execute.

Regards.

ActiveX component can't create object: 'Excel.Application' error on IE

Wed, 23 Jun 2010 13:59:26 GMT

the code is executed on the server, so you will need to have a 64 bits version of the Excel ActiveX if you want it to be executed from the 64 bits QlikView server process (i do not even know if it exists).

AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

biester — Wed, 23 Jun 2010 14:04:14 GMT

Overriding security and giving system access will not help much with a running excel.exe on the server as I suppose minority would rather prefer it on the client.

Minority,

to not going on supposing and to not assume as evident what might not be so evident: HOW are you accessing the qvw in the AccessPoint?

Rgds,
Joachim

Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

Wed, 23 Jun 2010 14:08:08 GMT

Dear biester,

In both cases (server or client) he shoud override security.

Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

Thu, 24 Jun 2010 03:06:42 GMT

Thank you all for your response!

Yes, I've set both Requested Module Security and Current Local Security to Allow System Access;

in Document Properties - Security tab - checked macro override security under User Privileges;

in User Preferences - Security tab - checked for Module(Allow CreateObject and FileAccess), Launch (Start Programs and Documents from Button, Script and Module), Confirm Launch from Macro.

Still getting the same prompt. =(

I'm accessing qvw files in AccessPoint through IE plugin.

Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

Thu, 24 Jun 2010 03:13:06 GMT

Also, Excel is not installed and won't be installed in the server...

Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

Thu, 24 Jun 2010 03:23:21 GMT

Before I added the CreateObject(Excel.Application) macro, in the file uses the following code:

CreateObject("WScript.Shell")

CreateObject("CDO.Message")

CreateObject("Scripting.FileSystemObject")

There is no issue executing the above functions. I didn't have to set macro override setting. Kinda confuse how the security works.

AW:Re: Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

biester — Thu, 24 Jun 2010 05:20:38 GMT

When accessing via IE-Plugin, the macro is being executed on the client (to be sure I tested it right now, also with Excel). Thus, the problem seems to be merely on the client (could have thought of that earlier, because if it were on the server, you wouldn't receive the error message, I suppose). So, maybe Excel is not installed properly, or the COM is not registered properly, or the access is not allowed. Perhaps this link helps a little:

http://markstechstuff.blogspot.com/2007/07/activex-component-cant-create-object.html

Rgds,
Joachim

AW:Re: Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

Sat, 26 Jun 2010 17:53:29 GMT

Thanks Joachim.

Ive read and tried the steps that I can try but to no avail. I could not follow all the steps as the Excel version is not the same as the one that I'm using.

Excel is installed properly cos I can do a send-to-excel via macro.

I went in DCOMCNFG and set the properties that I can set accroding to the website. Btw, this may sound like a silly question, is Excel a COM or .NET ?

Thanks!

ActiveX component can't create object: 'Excel.Application' error on IE

Mon, 11 Oct 2010 23:48:06 GMT

Hi,

your suggestion was really helpful, it worked for me.

Regards,

kingshuk

ActiveX component can't create object: 'Excel.Application' error on IE

Wed, 04 Apr 2012 14:07:38 GMT

thank you so much... we struggled a lot and finally got it becoz of u

Re: AW:Re: Re. :AW:Re. :AW:ActiveX component can't create object: 'Excel.Application' error on IE

jerrysvensson — Fri, 01 Feb 2013 13:26:00 GMT

Have you by mistake choosen the wrong security level when opening the application in Plugin?

Try Ctrl+Shift+M This will bring upp the Macro security dialog, the top radiobutton should be selected.