topic Re: VBA Tool to add macro code in Job in Talend Studio

VBA Tool to add macro code in Job

EnriqueLDE — Tue, 08 Jan 2019 10:51:51 GMT

Hello,

I'm looking for a VBA tool which allows me to define conditions to my jobs. I'm working with Excel Sheets and i need to use this tool to add my VBA macro code from Excel. Is it possible?

Thank you!

Re: VBA Tool to add macro code in Job

Anonymous — Wed, 09 Jan 2019 08:03:03 GMT

Hello,

Is your Excel files containing non-visible Names?

Please try to use tFileInputExcel component to see if it is OK with you.

Best regards

Sabrina

Re: VBA Tool to add macro code in Job

EnriqueLDE — Wed, 09 Jan 2019 09:29:08 GMT

Hi,

I'm already using tFileInputExcel to work with Excel files. But also i need to add a tool that allows me to insert vba code to modify this tFileInputExcel. If it's not possible i supose there's a tool to insert Java code instead. The aim is a tool where i can introduce code to modify Excel Files introduced by tFileInputExcel.

Thank you!

Re: VBA Tool to add macro code in Job

akumar2301 — Wed, 09 Jan 2019 11:39:50 GMT

you can call VBA script directly using tJava
like

Runtime.getRuntime().exec("wscript yourmacro.vbs");

so wrap your Macro code inside inside a Visual Basic Script and run it.

Re: VBA Tool to add macro code in Job

EnriqueLDE — Wed, 09 Jan 2019 16:35:47 GMT

@uganesh Perfect, that works. Thank you!

Re: VBA Tool to add macro code in Job

DBLONDEL1643728674 — Mon, 31 Oct 2022 09:10:55 GMT

Hello Akumar,

You can run it on linux ??