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.
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.
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?
