read same sheet from xslm files

Question

I have nearly 65 excel(xlsm) files all have the exact same structure. Only the data is different. I have a summary sheet in all of the files and would like to input summary sheets into Alteryx designer from all the files.

Please can someone show me how to do it.

MarqueeCrew · Accepted Answer

@ahsankhalid ,

I've worked through the reading of the xlsm's and used a Directory Tool to find them. Then used a dynamic input to read them all.  I also added the filename so that I know where each record comes from.

Cheers,

Mark