VBA Tool to add macro code in Job

[EnriqueLDE]

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!

[Anonymous]

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

[EnriqueLDE]

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! 

[akumar2301 · Accepted solution]

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.

[EnriqueLDE]

@uganesh Perfect, that works. Thank you!

[DBLONDEL1643728674]

Hello Akumar,

You can run it on linux ??