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.
Does anyone have an example using this macro? I get the error below after selecting the directory. I don't see anywhere to select sheets that I want. But that was the whole reason for using this tool. I can't get the person to use the same name for the workbook tab...
The field "sheet names" is not contained in the record
The Macro is supposed to include all sheets in all excel files by nature. The configuration is to exclude sheets names, which you can do by listing them at the bottom. If you can share your worklfow and excel files (can just have sample data), I can look at it and see what's causing the exact error.
Furthermore, the N output (where unmatched sheets are diverted) is empty, so that's good. And using a Summarise tool downflow, grouping by FullPath with min [Date] and max [Date] shows that all my sheets have been read in and all the rows in those sheets have been correctly read too.
In short, provided your N is empty and you check your Summarise outputs, you should be good to go.
PS here's a screenshot of the configuration I use for the Summarise checking: