Dynamic Input / Batch Macro - does not match a sheet or named range in error

[vinakota]

Dear Community, 

I am trying to consolidate multiple excel files using batch macros with file path. I am getting the following error message. I do have the full path and worksheet name added, however I am still running into issues. Appreciate any help the community can provide. Including below a couple of sample files and the workflow. 

Batch (54) Record #1: Tool #8: Part 1- Spreadsheet Simulation$A6:R78 does not match a sheet or named range in BRT_2_D3 (1).xlsm or the file is corrupted.

[Sebastiaandb]

Hi @vinakota ,

Try my packaged workflow. 

I made a new macro for you as yours wasnt included in the post :-). 

Let me know if it works for you! It should work as it works at my laptop :-) including your ranges. 

Greetings,

Seb

[vinakota]

Hello Sebastian,

Thank you for the response. Can you advise what was the issue. I am including the original Macro that I was using. Your solution seems to exclude the file name. I need the file name as an output. Can you take a look again?

Regards,

Srikant