Copied macro not working

[PuffinPanic]

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

[gabrielvilella]

The data that is entering the macro, do you have a list of all the files with the sheet names there? 

[PuffinPanic]

Hi,

Thanks for the quick response, yes, all of the file names are input into the macro.

[gabrielvilella]

If you could please share the macro and the file you are trying to read. Could be just a snippet. 

[PuffinPanic · Accepted solution]

I've actually just found the issue - there was a capital letter (just one!) in the excel tab name in the macro that was not present on the excel spreadsheet. Clearly, I hadn't taken case sensitivity into account. I will be more careful in future.

Gabrielviella, thank you for looking into this for me. I appreciate you helping me to try to find the needle in the haystack.