Calling Excel Macro from Talend Job

One Star

Calling Excel Macro from Talend Job

Dears,
Is it possible to call excel macro from a talend job. Can you please help me with the screen shot. thanks in advance.
Regards,
Ram
Six Stars

Re: Calling Excel Macro from Talend Job

You need custom code for that ( java, perl or command line call ).
Investigate excel COM model.
One Star

Re: Calling Excel Macro from Talend Job

Hi,
The excel is an all in one software. it can have data, screen, report and processing logic and all in one software. The excel is one of the good software for developing single-user application.
Talend provides facility to use Excel as input and output data file and guess it does not provide facility to execute the logic defined inside an excel in a form a macro.
Thanks and Regards,
Pravu Mishra.
Six Stars

Re: Calling Excel Macro from Talend Job

I repeat not natively in Talend, but you can run a quick external script in Talend ( that calls COM methods of excel ), for example you can call via command line component in Talend a powershell script like:
--------
$excel = new-object -comobject excel.application
$workbook = $excel.workbooks.open($myfile)
$excel.Run("MyDefinedMacro")
$workbook.save()
$workbook.close()
$excel.quit()
-------
would do the trick.
hope it helps
bye!