topic create external task on QMC (VB) in QlikView

create external task on QMC (VB)

alec1982 — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

I have a VB script stored on its own on one of my drives. I can simply double click on it to run. need to schedule it using QMC external task and add trigger on it. I have done many of those for exe and ps1 files but not vb.

the task is failing and I guess it is due to the command line statement being wrong..

"E:\Data\file.vbs"

any idea if I need to add any wording here?

Re: create external task on QMC (VB)

marcus_sommer — Tue, 11 Oct 2016 14:48:15 GMT

Try this:

SET vCSCRIPT = 'c:\windows\system32\cscript.exe';

EXECUTE $(vCSCRIPT) "D:\ReadAndWriteExcelSheets.vbs";

- Marcus

Re: create external task on QMC (VB)

alec1982 — Tue, 11 Oct 2016 15:05:02 GMT

I am actually looking within the QMC outside of the apps.I found that I need to add wscript then wrap the command line statement with "".