Batch macro workflow not working - only output 1 record

[Sukisuki]

Hey, anyone can help me with my batch macro? I'm trying to use a batch macro to load multiple excel files within a folder. The workflow worked perfectly previously but somehow not working now. The folder (directory) has 3 excel files and each one has multiple records. When running the macro in the standard workflow, it only returned the first record of the first file and only one iteration was run. Attached are the screenshots of the workflow and also the configurations. Appreciate for any suggestions!

[JosephSerpis]

Hi @Sukisuki are you specifying the sheet name of the excel files that you feed into the Batch Macro? This article might help you. 

[CharlieS]

If I were to guess, the only file that worked is the only one that has a "FY19 Scope List" sheet. The Directory tool will pass the file path, but not the sheet name(s) from that file. Your batch macro will need to know the sheet name so that can be updated for each file. 

[JosephSerpis]

Hi @Sukisuki if you don't know the sheet names then the solution of this post should help you as it finds the sheet name then updates the file name then puts through a batch macro.

[Sukisuki]

Thanks for the suggestion, I appended the sheet name to the file path to specify the sheet I'm looking for (which is sent to the macro as control parameter), is this correct? But I still have the same output (one record only).

[Sukisuki]

Thanks for the quick reply. All test files have the "FY19 Scope List" sheet and they are in the same format. Attach here the workflows and test files for your reference.

[JosephSerpis]

Hi @Sukisuki can you try again but take out the the single quotations marks and $ from the sheet name.

[JosephSerpis · Accepted solution]

Hi @Sukisuki  thanks for your sharing your workflow I ended up having to rebuild your batch macro to make it work. Attached the workflow let me know what you think?