How to: Import one specific sheet from multiple files

Question

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 Answer

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