How to: Import one specific sheet from multiple files

[Wojtek_Dz]

Hi, i tried solve my case but I'm stuck.

I want to import one sheet e.g. "Please complete" (there are also other sheets) from all 12 xlsx files.

Schema of w-flow:

Macro 1: importing all sheet names

Macro 2: Import data from selected sheets

After 2nd macro I get error:  XLSX input (12) Record #1: Tool #1: 'Please complete' does not match a sheet or named range in C:\Users\XXXXXXXXXXXXXXXXXXXXX or the Excel file is corrupt.

Do you have know an answer, how to solve this problem ?

Thanks 

[Jonathan-Sherman · Accepted solution]

Hi @Wojtek_Dz,

I don't think there's any need to have the extra characters around the sheet name field,

Replace([FileName], "<List of Sheet Names>", [Sheet Names])

Kind regards,

Jonathan

[james9311]

I am trying to do something similar and have been searching high and low for the solution. Could you please share how your macros are set up?