VBA Copy and Paste Multiple CSV files into Workbook

tobermory

New Member
Joined
Jun 4, 2012
Messages
42
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,
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,127,610
Messages
5,625,814
Members
416,138
Latest member
Pizzaman22

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
Top