Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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)
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
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
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.
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).
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
Dear biester,
In both cases (server or client) he shoud override security.
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.
Also, Excel is not installed and won't be installed in the server...