Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Vb script

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.

3 Replies
JonnyPoole
Former Employee
Former Employee

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 ?

Not applicable

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:

Execute.jpg

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).

UserPref.jpg

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.

brindlogcool
Creator III
Creator III
Author

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