Help reading multiple xlsm files

Hi

I have tried several macro's without getting any closer.

I have attached one of the files I want to read. (I get several files, with 100% same structure) Therefore I want to be able to read several files at once. Its the sheet PurchaseAccountMapping and I need to read from line 4.

I found one macro that could read the files, but i was not able to specifi the start line.. and im not able to add it myself when I dont have a classic input object.

So any help would be appriciated.

Sample workflow.yxzp

Macros

Accepted answers

Sashikumar

I Create a module it will read all your .xlsm (PurchaseAccountMapping) sheet details.

Give me a like and make it resolve if my module solve your major problem.

Spoiler

Sample_sk.yxzp

All comments

Luke_C

Hi @Hamder83

Is it possible for you to share a 2nd excel file or the macro you tried? You should be able to specify the start row, and even if you can't you can use a sample tool to skip the first 4 rows.

Hamder83

Hi

I have a macro now, when I use it it loads the folder correctly - but only loads in one of many files, despite them having exactly the same structure.

Ive attached the macro, and the sample files.

Sample.yxzp

Sashikumar

I Create a module it will read all your .xlsm (PurchaseAccountMapping) sheet details.

Give me a like and make it resolve if my module solve your major problem.

Spoiler

Sample_sk.yxzp

Hamder83

@Sashikumar sorry for the late reply, this works. Gonna give you credit for the solution 🙂

Thank you

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335