using VBS from Talend Studio

[Anonymous]

Bonjour, 

I have a excel file produced by a long talend job. When "users" receive the file by mail, they open another excel file containing a VBA macro to adjust the content.

I found some posts explaining that VBS (Visual Basic Scripts) can be executed from a tJava.

I tried (in the tJava) : 

Runtime.getRuntime().exec("cmd /c start C:\Talend\Data\PRD\\TRAX\Work\VBSscriptHIL.vbs"); 

but at execution, I have Error found / Warning : 

General : Invalid escape sequence (valid ones are \b \t ...

[JR1 · Accepted solution]

Try this:

Runtime.getRuntime().exec("cmd /c start C:\\Talend\\Data\\PRD\\TRAX\\Work\\VBSscriptHIL.vbs");