Miche25
03-05-2016, 03:28 AM
I am trying to write a macro to import data from 5 separate csv files and import into 5 separate worksheets (i.e Sheet1 through to Sheet5) within my excel workbook.
The thing is, I already have the path and file names of the csv files I would like to import data from in cells A1 to A5 within Sheet6 of the workbook (I want to use cell values so the user can enter the dates of the files to be imported going forward).
The files of which I am importing data from are daily download files with dates in the file name (for example, 20160101.csv) I don't want to have to open these files every week and copy and paste the data into my workbook.
How can I do this?
The thing is, I already have the path and file names of the csv files I would like to import data from in cells A1 to A5 within Sheet6 of the workbook (I want to use cell values so the user can enter the dates of the files to be imported going forward).
The files of which I am importing data from are daily download files with dates in the file name (for example, 20160101.csv) I don't want to have to open these files every week and copy and paste the data into my workbook.
How can I do this?