Error - vbscript run from java code

Question

i'm using one vbscript file to convert mass excel files into txt files.It is working fine.

I want to do the same operation through the java code . I'm trying to execute the file from java code like

 try {
            Runtime.getRuntime().exec("wscript C:\\Datas\\xl2tab.vbs");
        } catch (IOException ex) {
            Logger.getLogger(convertFile.class.getName()).log(Level.SEVERE, null, ex);
        }

I'm getting an error like

enter image description here

Anyone have an idea to run the script file from java code..?

Excuse me for stating the obvious: It is running wscript, and it is running your VBS script. Within the VBS script it is failing to find the file that it mentions. It fails at line 52. We can't really guess what is going wrong inside the script without a listing… — Graham Griffiths
– Graham Griffiths, Commented Jul 19, 2013 at 9:08
The script is running. Have you looked into the possible causes mentioned in the error message? — Ansgar Wiechers
– Ansgar Wiechers, Commented Jul 19, 2013 at 9:24

CarlJohn · Accepted Answer · 2013-07-19 10:19:41Z

1

The problem is that the script takes current directory for converting excel files.As i'm running the java code from Netbeans, it takes the netbeans project folder as current directory and trying to convert.

I solved by passing the folder path(where files are placed for conversion) as parameter variable to script.

Now i can run the script from java code.So, it is better to use variables for folder path ..

answered Jul 19, 2013 at 10:19

CarlJohn

7272 gold badges9 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Error - vbscript run from java code

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