Share
Report
7Hi
Hoping someone is able to help.
I have built a process where given some inputs, an excel macro is run which calls a specific flow, scrapes a load of data from a website, writes it to excel and calls another macro which then performs calculations with the data.
This all works fine - and the only reason it does is because my initial macro runs the flow and then ends, the flow then runs and the final macro is run as the last action in the flow. So the flow ends when the final macro finishes. This works for a single set of inputs.
What I'm trying to do now is to create a batch process where I can feed a list of inputs and get the process to loop through each set of inputs given. I've set it up so that the initial macro reads in the inputs for the first case, runs the flow and waits whilst the flow is running. Once the flow finishes, I want it to then perform the calculations using the data. Once this finishes, I want it to move on to the next set of inputs and repeat.
The issue I have is - the flow cant seem to attach itself to a running instance of excel whilst the macro is running and waiting for the flow to finish. Is this normal? If so, is there any way around it?
All responses (
Answers (
