using VBS from Talend Studio

Anonymous — Sat, 16 Nov 2024 04:53:28 GMT

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

Re: using VBS from Talend Studio

JR1 — Thu, 22 Aug 2019 12:56:13 GMT

Try this:

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

topic using VBS from Talend Studio in Talend Studio

using VBS from Talend Studio

Re: using VBS from Talend Studio