Create a batch macro for Excel with multiple files and multiple sheets

[Shaman]

I have multiple files with multiple sheets (excel). 

One sheet (same name and same structure) from each file shall be extracted or combined with Union tool.

I would like to use Directory tool as batch information for Input tool and create a macro for it.

Already looked into several solution but got stuck within the implementation.

[mceleavey · Accepted solution]

Hi @Shaman ,

I've attached an example workflow and a couple of tools that will do the trick.

You will simply need to filter out by tab name at the end, but this will load in all sheets and all tabs using the Directory tool.

Hope this helps,

M.

[Shaman]

Wow, very cool  and works perfect!

Is there any hint how to incorporate when the data import shall start not on first line?