
Steven Behr
Member
Members
Power Query
Power Query

Forum Posts: 85
Member Since:
January 30, 2020
January 30, 2020

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

Mynda Treacy
Admin

Forum Posts: 4518
Member Since:
July 16, 2010
July 16, 2010

Hi Steven,
Not sure why you aren't using Power Query to import the data. VBA is the old way to automate the gathering and cleaning of data.
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Aminu Sule
Samuel Ramirez
Abdifatah Osman
mohad borhom
Abayomi Adedeji
Ganesh MVS
Gilbert Lemek
Ashleigh Farquharson
Jayz Luu
Fred Smith
Forum Stats:
Groups: 3
Forums: 24
Topics: 6364
Posts: 27828
Member Stats:
Guest Posters: 49
Members: 32346
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
