topic Re: How to call command prompt script in Vb script in QlikView

How to call command prompt script in Vb script

jagannalla — Thu, 19 Mar 2015 08:07:35 GMT

Hi All,

I want to call command prompt script in vb script.

For eg: We can place reload command in bat file and when we run bat file it will load the qv file.

Similar to that when I click the button I want to run command prompt code directlyI don't want to create bat file to run the command prompt code.

- I only don't want to run reload command.

- I want to run my own command prompt available, let say xcopy or copy, writing csv file. etc.

Thanks,
Jagan

Re: How to call command prompt script in Vb script

Peter_Cammaert — Thu, 19 Mar 2015 08:18:39 GMT

I'm not sure if I tuly understand your requirement. Is your VBScript a stand-alone program, or is it embedded in a QVW document?

In VBScript, there is a WShell object that lets you execute DOS commands as if you opened a CMD window. Look around the internet for more information, there must be thousands of examples.

Best,

PEter

Re: How to call command prompt script in Vb script

tresB — Thu, 19 Mar 2015 08:26:48 GMT

Google it, you would find examples like:

dim filesys
set filesys=CreateObject("Scripting.FileSystemObject")
If filesys.FileExists("c:\sourcefolder\anyfile.html") Then
filesys.CopyFile "c:\sourcefolder\anyfile.html", "c:\destfolder\"
End If

Re: How to call command prompt script in Vb script

jagannalla — Thu, 19 Mar 2015 09:13:54 GMT

Hi,

I want to run,

the below command

curl -u username:Test@345 -F "token_id=918080a1-cabb-45fa-8aee-ee496fa896bb" http://demo.XXXXX.com/rest-api/v1/getPredictions/?format=json

Re: How to call command prompt script in Vb script

Peter_Cammaert — Thu, 19 Mar 2015 14:57:30 GMT

Use something like:

Set oShell = WScript.CreateObject("WSCript.shell") oShell.run "curl -u username:Test@345 -F " & chr(34) &

"token_id=918080a1-cabb-45fa-8aee-ee496fa896bb" & chr(34) &

" http://demo.XXXXX.com/rest-api/v1/getPredictions/?format=json"

Re: How to call command prompt script in Vb script

jagannalla — Fri, 20 Mar 2015 02:21:15 GMT

Hi Peter Cammaert,

It gives syntax error.

Thanks,

Jagan

Re: How to call command prompt script in Vb script

Peter_Cammaert — Fri, 20 Mar 2015 08:14:40 GMT

Where?