Call a Knime Workflow from excel

Currently, I have a workflow that has to be opened tu be ran. But I would like to make a VBA code that automatically calls that workflow and runs it Without having to manually open knime and execute the workflow.

The problem is I made a workflow that needs to be ran every week, and the end user doesnt know how to use KNIME, so he will not be able to run it. I was planning to create an excel file with a VBA macro that calls the KNIME workflow when it the macro is executed.

I would like to mention that the knime workflow reads several excel files and writes only one excel file. None of those files will contain the macro that I would like to do, neither the input files nor the output file.

Hi @Eugenio_Gastelum
For automating KNIME Workflows, we are offering the KNIME Server, which comes with a scheduler. In case you want to know more, here is all you need: https://www.knime.com/knime-server

Cheers, Iris

2 Likes

Hi :slight_smile:

What if I want to create this with using my desktop version?

Thank you very much in advance!

See here

1 Like

You could use VBA to run the batch script (Info provided by @izaychik63 )
br

1 Like