Import multiple excel files from directory

[kaneb3]

Hi,

I'm trying to create a simple workflow where a user selects a directory and all the workbooks in that directory are imported and the data from them joined together.

The workbooks all have the same sheet name "Market AdSpend Forecast (LC)" and all have the same schema.

I've looked around, but i cant seem to find a method that works for me!

Would anyone be able to help me with an example?

Thanks very much

[JosephSerpis · Accepted solution]

Hi @kaneb3 have a look at this article it should help you on your way. You will likely need to use the Interface tools to give a user the option of selecting a directory either as a Macro or App.

[kaneb3]

this helped a lot, thank you!