How to run VBScripting in KNIME?

[caratsweet]

Hi,

I am trying to do data manipulation in KNIME on a report that I pull out from SAP.

The report is generated automatically via VBScripting in SAP.

Would it be possible for me to run the VBScripting in KNIME directly?

Currently I save the vbscripting file locally and run it by clicking on it outside of KNIME.

Would be great if I can run it directly in KNIME, so the user can complete everything in one shot.

Thank you so much in advance.

[takbb]

Hi @caratsweet , take a look at @gonhaddock’s post here:

Knime -vba excel macro

Hello @Soldado I don’t thin that it does exist a node that can execute macros inside of an excel file. Ina brainstorm mood and aiming to help with your challenge … You can execute the ‘excel_file.xlsm’ with the help of ‘Execute Shell Script’ node, from AF Utility Nodes’ extension. This node will retain the workflow progress until the task ends up (the excel file is closed / the excel app is quit) The rest of the work would had to be implemented in the excel file itself: Y…

I would think executing a vbscript would use a similar mechanism to that mentioned.