How to Input Directory into Batch Macro

Question

Potentially a very easy to answer question, how do I configure the input of my macro to read files from a directory? Currently my directory has 2 files:

In the below image, in red section, I previously had one of the files set as the 'File Input' and the macro worked as expected. But I don't know how to set it up so it will read one file at a time from my directory.

When I try and use a directory with the Macro, none of the variables are recognised.

Many thanks

LocationID-JoeBloggs.xlsx

LocationID-JohnSmith.xlsx

afv2688 · Accepted Answer

Hello @HenpetsGordres1 ,

To do that you would need to change the procedure and add a control parameter to an input. You would modify the filename with each file and therefore process every file one after the other.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards