Help - simple batch macro - multiple sheets

Hi

I need some help getting this to work please.

I'm trying to create a batch macro that can read all .xlsm files from a folder, and pick a specific sheet from each file, and then combine them.

I've attached what I have done. and included two sample files.

Hope this makes sense?

SampleFlow.yxzp

Macros

Accepted answers

mceleavey

Hi @Hamder83 ,

I've attached a couple of tools and a working example.

The first tool loads in all tab names of all sheets in the folder you've selected, and the second dynamically loads them all in.

You can place a filter tool after the first macro to reduce to the tabs you want if that is applicable.

Hope this helps,

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

Multi Sheet Import Example.yxmd

All comments

mceleavey

Hi @Hamder83 ,

I've attached a couple of tools and a working example.

The first tool loads in all tab names of all sheets in the folder you've selected, and the second dynamically loads them all in.

You can place a filter tool after the first macro to reduce to the tabs you want if that is applicable.

Hope this helps,

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

Multi Sheet Import Example.yxmd

Hamder83

Hey @mceleavey

Thank you very much, it seems to work 🙂

I'll accept as solution 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703