Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?

1 Solution

Accepted Solutions
Not applicable
Author

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)

View solution in original post

15 Replies
Not applicable
Author

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)

Not applicable
Author

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

biester
Specialist
Specialist

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

Not applicable
Author

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.

Not applicable
Author

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).

biester
Specialist
Specialist

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

Not applicable
Author

Dear biester,

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

Not applicable
Author

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.

Not applicable
Author

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