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

Question

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.

R_1diCTbk54W4YfnM~BRT_1_D3.xlsx

R_1feXS8ce3Aut9Jz~BRT_1_D2.xlsx

Macro_IR_Spreadsheet_Consolidator_wo_Transpose.yxwz

vinakota · Answer

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

Sebastiaandb · Answer

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

Macro_IR_Spreadsheet_Consolidator_wo_Transpose.yxzp