Forum Discussion
Batch Import of CSVs into workbook as individual worksheets
Hey Everyone, I am trying to import a series of csv files into a workbook with worksheets for each csv file. Right now I have figured out how to import all of them into a single worksheet, but I ...
What method do you wish to use? And are all CSV files in one folder? And is it all files in that folder?
If it is one folder of all the files in tht folder the VBA is pretty easy to loop through all the files, importing the data to a new sheet and naming that sheet the same name as the file name.
If it is one folder of all the files in tht folder the VBA is pretty easy to loop through all the files, importing the data to a new sheet and naming that sheet the same name as the file name.
trishia11271 All the files are in the same folder, but I am uncertain of the VBA process.