VBA Copy and Paste Multiple CSV files into Workbook

T

tobermory

New Member
Joined
Jun 4, 2012
Messages
46
Hello there,

It appears you cannot take multiple files from a folder and put them in individual tables or queries using PowerQuery (PowerQuery - Multiple csv files into multiple tables)

Is there a VBA to essentially, open multiple CSV files from the same folder and copy the sheet into the 'holding' spreadsheet? I have around 50 csv files, each csv file only contains one worksheet (each sheet has a unique name) so ideally I'd like to keep the sheet name in the 'master' spreadsheet too.

Sincerest thanks,
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You must log in or register to reply here.

Similar threads

M
  • Question
Macro - Merge all files into one sheet
Replies
2
Views
191
MountainFog
M
M
  • Question
Getting Power Query data to an Excel worksheet
Replies
4
Views
152
MichaelMorris
M
T
  • Question
Loop through folder and copy data into master spreadsheet
Replies
2
Views
245
TaskMaster
T
K
  • Solved
VBA to copy column/data from two .csv files to one combined file.
Replies
6
Views
484
kbilly70
K
T
  • Solved
Amend column contents within multiple CSV files where all of the files contain columns with the same order and format
Replies
8
Views
440
Herakles
H

Forum statistics

Threads
1,214,585
Messages
6,120,394
Members
448,957
Latest member
Hat4Life

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top