Hi all,
I have a basic macro (copied from a post on here earlier) which takes the data from multiple excel spreadsheets from within a folder structure (50 sheets in this case) and merges it. The schemas in the spreadsheets are all the same.
This is working fine on one workflow, but when I have copied and pasted it to a second workflow (and changed the appropriate inputs to the new file structure I want to use) it doesn't work.
I've compared very carefully the settings of all of the tools and everything appears to be identical between the first and second.
Full file path (inc excel tab name) passed into macro
Value and 'replace string' values are identical
Output after macro includes only 1 file path - there should be 50
In the non-working version, I am only getting the output from the specified 'example' file in the macro workflow, but repeated multiple times, I think once for each file that should be loading.
My inability to work out what it wrong is driving me a bit crazy - especially considering it's a direct copy and I haven't changed any settings other than the file. Can anyone suggest anything to look at that could be causing the issue in the copied version of the macro please?
Thanks
