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.
A method to accomplish this is to use a directory and a dynamic input tool. I've created a better directory macro that splits out all excel sheets as separate lines in the directory. I've also made a dynamic input batch macro that specifically works with excel files (D output for the data, F output for the directory files that failed, S output for the directory files that succeeded) You can find them attached below.