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
Hi Steven,
This sounds like a job for Power Query - have you tried it?
https://www.myonlinetraininghub.com/introduction-to-power-query
Please supply sample data files and an example of your expected result if you need more help.
Regards
Phil
Hi Phil,
Yes I have considered Power query but I think its to much data to import and to slow.
I do have a code for this but I did need to run more test.
I will share this code tommorrow morning
Steve
