[VBA] Select multiple files, import one by one

Hi everyone,

I am struggling with some VBA code I got from someone else along the road. Currently, the file select box only allows one file per macro execution, but I would like to have the select box allowing to select multiple files (all same file format .xls, all in same folder) and then import the files one by one, basically running the vba code one by one.

Please Login or Register  to view this content.

Anyone who could point me there? I googled and searched the forum but dont get very far...

Thanks,
A2k

Really not getting anywhere. My code so far gives me an application error when trying to address the cells via with activeworkbook. Any ideas?

Please Login or Register  to view this content.

Basically what I am trying to do is to import the files one by one and have the data in one column after another.

Thanks,
A2k

hi Armitage2k, sort of that:

Please Login or Register  to view this content.

Excellent, thank you all very much!
A2k