Hello,
I have a question of how to do the following:
I have a workflow that generates an excel file, let's call it TEST.xlsx(which gets overwritten every time the workflow runs - once per day/5 days a week). I also have the C.R.E.W macro "Conditional Runner" in the same workflow that should run only if it receives some data (This tool executes another workflow).
I want the TEST.xlsx to be generated first, and ONLY AFTER the file is done updating, run the conditional runner tool, which checks if there's data present, if there is, the MACRO calls a different workflow that uses the SAME TEST.xlsx file to generate a text file in another folder.
Right now, it doesn't work when I run it the first time, but only after I run it the second time.
I believe it's because the conditional runner is being executed before the TEST.xlsx file is overwritten with the new daily data.
Am I missing something??
Any help is greatly appreciated.
Many Thanks!!
Cesar,
