How to execute VBS script in Java?

Question

How to execute VBS script in Java? What is he preferred way? I found in Internet so many advices, so I don't know what is better...

1.

  Runtime.getRuntime().exec("cscript //NoLogo " + file.getPath());

2.

Runtime.getRuntime().exec("wscript.exe " + file.getPath())

3.

String script = "C:\\work\\selenium\\chrome\\test.vbs";
String executable = "C:\\windows\\...\\vbs.exe"; 
String cmdArr [] = {executable, script};
Runtime.getRuntime ().exec (cmdArr);

4.

Runtime.getRuntime().exec("cmd /c a.vbs");

5.

Desktop#open(new File("c:/a.vbs"));

And It is not all.

What kind of this to choose? I need to execute following script:

If Not IsObject(application) Then
Set application = SapGuiAuto.GetScriptingEngine
End If
If Not IsObject(connection) Then
Set connection = application.Children(0)
End If
If Not IsObject(session) Then
Set session = connection.Children(0)
End If
If IsObject(WScript) Then
WScript.ConnectObject session, "on"
WScript.ConnectObject application, "on"

AlexR · Accepted Answer · 2012-11-27 14:27:13Z

3

VB scripts are typically executed using utility named cscript. I do not remember where this utility is located but it is definitely in path, so you can just run it directly like cscript yourscript.vbs. Now just use Runtime.exec() or ProcessBuilder from java.

And for your convenience avoid using back slashes in java code. Use forward slash instead. It works in windows perfectly and do not require duplications like \\.

answered Nov 27, 2012 at 14:27

AlexR

116k16 gold badges137 silver badges216 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to execute VBS script in Java?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related