topic Re: Execute statement problem in QlikView

Execute statement problem

Thu, 11 Apr 2013 07:37:34 GMT

hey there,

i need to execute a vbs file directly from the load script of QV.

my actual code is this one:

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

EXECUTE $(vCSCRIPT) C:\Documents and Settings\user\Desktop\VB\Delete_first_X_lines_cycle.vbs;

No errors are given but the file is not executing. The document has execute permissions and the vbs when manualy started works properly.

Any ideas?

Thnks in advance

JuanPedro

Fri, 12 Apr 2013 05:57:14 GMT

Still not able to run .vbs with execute.

My momentary workaround is to execute a .bat file that runs the .vbs

I dont really like this solution so any hint is appreciated.

Have a nice day

ToniKautto — Fri, 12 Apr 2013 06:50:12 GMT

The string that will be executed is below. Will it work if you execute it manually in a command prompt?

c:\windows\system32\cscript.exe C:\Documents and Settings\user\Desktop\VB\Delete_first_X_lines_cycle.vbs

I would guess that the path including white spaces would require quotes in order to be executable.

c:\windows\system32\cscript.exe "C:\Documents and Settings\user\Desktop\VB\Delete_first_X_lines_cycle.vbs"

Fri, 12 Apr 2013 08:24:57 GMT

Try calling Call "functionname()" in .vbs file. also try to pipe the output to some text file.

eg. cscript myScript.vbs >> c:\scriptslog\log.txt

kaushiknsolanki — Fri, 12 Apr 2013 13:00:07 GMT

Hi,

Just try this.

EXECUTE cscript C:\Documents and Settings\user\Desktop\VB\Delete_first_X_lines_cycle.vbs

Regards,

Kaushik Solanki

marcus_sommer — Fri, 12 Apr 2013 13:13:06 GMT

with quotas it works ...

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

EXECUTE $(vCSCRIPT) "C:\Documents and Settings\user\Desktop\VB\Delete_first_X_lines_cycle.vbs";

- Marcus

Mon, 15 Apr 2013 08:27:25 GMT

The quotes did the job!

usefull the log file aswell.

thnks everyone for your time and anserws

Have a nice day.