Hello,
I need to call an Excel macro from Talend. In order to do that I wrapped my commands in PowerShell script which I can call either from powershell or cmd.
Example below runs fine:
C:\ETL_Talend\macros>cmd /c powershell C:\ETL_Talend\macros\Talend_run_Excel_macro.ps1
However, when I run the same line from Talend's component tSystem I get an error:
***************
Starting job CallExcelMacro at 15:39 08/02/2011.
'powershell' is not recognized as an internal or external command,
operable program or batch file.
connecting to socket on port 3443
connected
disconnected
Job CallExcelMacro ended at 15:39 08/02/2011.
***************
Please help.
Thanks,
Peter.
emaxt6, the command you suggested does not work as is. It seems working fine when I remove -File parameter.
"cmd /c start powershell -noninteractive c:\\temp\\test\\launch.ps1"
Thanks a lot for your help!
Peter.
anyway I've opened a bugtraq http://www.talendforge.org/bugs/view.php?id=18916 to let the Talend team investigate... I think powershell waits on its standard input descriptor from parent job before proceeding ...
Hi Peter,
As you have experience in powershell and running VB Macro,Can you please write down the steps to create a powershell and calling that in talend(All required steps).
Appreciated your help.
Thanks,
Pranij
Hello, I need to call an Excel macro from Talend. In order to do that I wrapped my commands in PowerShell script which I can call either from powershell or cmd. Example below runs fine: C:\ETL_Talend\macros>cmd /c powershell C:\ETL_Talend\macros\Talend_run_Excel_macro.ps1 However, when I run the same line from Talend's component tSystem I get an error: *************** Starting job CallExcelMacro at 15:39 08/02/2011. 'powershell' is not recognized as an internal or external command, operable program or batch file. connecting to socket on port 3443 connected disconnected Job CallExcelMacro ended at 15:39 08/02/2011. *************** Please help. Thanks, Peter.
