This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.
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).