Afternoon all,

I have got a VBA databse that imports excel files by selecting 1 file from a folder and import the data to a sheet that I got opened.

But what I want to do now is automatically going to a folder selecting all 15 excel files from a folder and range is from A1-L1 and there will multiple lines and import all excel files from sheet1 to the workbook opened to sheet1.

I tried various codes to no end and what like some help on this.

Thanks

Steve