topic Re: execute command and QMC in QlikView

execute command and QMC

Alex — Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I am trying to execute a .vbs file which is running an embedded macro in Excel.
It works from my local pc but when it is deployed to QMC, gets completed successfully but doesn't execute the macro.
All security checks are enabled in settings.ini and .qvw so, don't know what's the problem.

My .qvw script:

EXECUTE cscript.exe "..\..\Folder_1\Folder_2\Script.vbs";

Script.vbs:

Option Explicit

Dim xlApp, xlBook, scriptdir

scriptdir = CreateObject("Scripting.FileSystemObject").GetParentFolderName(WScript.ScriptFullName)
Set xlApp = CreateObject("excel.application")

Set xlBook = xlApp.Workbooks.Open(scriptdir & "\Macro_file.xlsm",0, False)
xlApp.Run "RefreshAll"
xlApp.Quit

Set xlBook = Nothing
Set xlApp = Nothing

Thanks in advance.

Re: execute command and QMC

zhadrakas — Fri, 29 May 2020 09:10:39 GMT

recheck both of these parameters

Security Tab in User preferences in QVW (STRG+ALT+U)

AllowExecuteCommand=1 in Settings.ini

Path: C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch

Under [Settings 7] add following line

AllowExecuteCommand=1

after this you need to restart the qlik Services

Re: execute command and QMC

Alex — Fri, 29 May 2020 09:43:04 GMT

This is already correctly set up.

The point is that the task gets completed successfully but it is not triggering the macro.

Re: execute command and QMC

zhadrakas — Fri, 29 May 2020 09:48:36 GMT

alright.

did you test that locally with the user that is assigned to the qlik Service?

Re: execute command and QMC

martinpohl — Fri, 29 May 2020 09:57:58 GMT

see here

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/Execute.htm

how to allow execute on server

Regards

Re: execute command and QMC

Alex — Fri, 29 May 2020 10:48:10 GMT

Hi,

I already checked but it is not working.

Same happens with .bat files, which do work when I execute them manually but not from the QMC.

I've tried almost everything and don't know what's the problem.

Thanks both!

Re: execute command and QMC

marcus_sommer — Fri, 29 May 2020 12:36:30 GMT

There are a lot of possibilities which may cause the failure. To exclude most of them unless the QMC related ones login to the server with the QV services-user and run there the reload with the desktop client. The usual missing access rights, invalid paths, missing Excel configurations/licences and similar should be popup more or less obvious.

- Marcus

Re: execute command and QMC

Alex — Fri, 29 May 2020 13:28:57 GMT

HI Zhdrakas/Marcus,

I've tried login with the QV services-user and run in the server the .qvw with the desktop client.
I've attached the error (ActiveX component can't create object 'excel,application')

The .qvw code which contains the execute statement is completed successfully when I execute it with my user either in local or the server.

Regards,

Re: execute command and QMC

marcus_sommer — Fri, 29 May 2020 14:28:03 GMT

This error could mean that there is no Excel installed, Excel isn't licenced, Excel settings didn't allow the use of ActiveX or ActiveX is globally denied (it's a very powerful feature and therefore relevant for security and often restricted) or something similar.

Just start Excel on the server directly and if everything worked you may execute some simple Excel macro with an ActiveX statement like CreateObject.

- Marcus

Re: execute command and QMC

Alex — Tue, 02 Jun 2020 09:44:34 GMT

Indeed! Excel was not installed in the server.

I will talk to the team and try after installing the software. Will let you know.

Thanks for your support!