topic Re: Vb script in QlikView

Vb script

brindlogcool — Fri, 29 Aug 2014 19:09:21 GMT

I am trying to run the vb script in the QlikView script using the command

EXECUTE cmd.exe /C "\\test\t.vbs"

I am getting the error as "UNC Paths are not supported. Defaulting to Windows directory"

Also it is prompting to run the script. I would like to know how to run the vb script in the silent mode without prompting to the user to run it and also how to allow the unc paths.

Re: Vb script

JonnyPoole — Fri, 29 Aug 2014 20:40:47 GMT

i'm kind of a newbie to this sort of question but.... if you open a command prompt on windows Start -> CMD

can you execute the vbs script via a UNC path ?

Re: Vb script

Sun, 31 Aug 2014 17:13:04 GMT

Hello,

To run the execute command without getting prompts:

first, make sure to check the flag "Can Execute External Programs" from the edit script window, as shown in the below image:

then, under Settings > User Preferences > Security tab, you'll have to check the flag "Script", as also shown in the below image.

note that this is usually done when you trust the source of your documents (check the note in picture).

As to running unc paths, I've searched a bit and read about the pushd command that takes as parameter the unc path and creates a drive that directly points to it, and the popd command that releases it.

Maybe you could create a batch file (locally / accessible location) in which you write these commands:

pushd \\test

t.vbs

popd

let's say you placed your batch TestBat.bat file under C:\Batches\

so in your qv script your execute command would be like:

execute cmd.exe /C "C:\Batches\TestBat.bat";

Hope this solves your request.

Re: Vb script

brindlogcool — Wed, 03 Sep 2014 16:04:31 GMT

Thanks for your response. How to run the batch file in the silent mode.