BLACK FRIDAY SALE 20% OFF ALL COURSES

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: 4647
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: Sherry Fox, Jill Niemeier, Pam Baillie, Stacey Wells, Sheryl Gill, Ben Penney, Phil Collins, Todd Heckman
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1864
SunnyKow: 1432
Anders Sehlstedt: 886
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 241
Hans Hallebeek: 227
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Anya Ledwith
Mark Melvin
Stuart McInnes
Naji Moukhachen
Robert Mason
Debora Cohen
Kris Whitaker
Rajesh Jawajala
Todd Heckman
Sarah Dennis
Forum Stats:
Groups: 3
Forums: 24
Topics: 6641
Posts: 29138
Member Stats:
Guest Posters: 49
Members: 33095
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
