We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Same Workflow and Macro as everyone else seems to have.
I didn't realise this for a while but in order for the batch macro to run more iterations you need to make sure there is a tool after in it your workflow. This may be common knowledge but it took me a while to work out that this was my problem!
My solution is not really MY solution (gathered from all of your solutions, but I made it work...) A lot of learning points from this one:
- I did not consider the helper files as irrelevant for importing with the macro
- I did not know of updating @FileFormat with a numerical value; is there any documentation on this?
- I did not know about the FileGetExt function, solved it with RegEx at first
Did not use the @FileFormat solution in the end, found the 'Update Input Data Tool' option mentioned by @Garrett more elegant.