I want to link my 19 .csv files into one excel workbook. Each .csv has to be imported to one spreadsheet.
The most important part is it has to be linked, because a lot of .csv might be overwritten multiple times so excel should have the update automatically.
I have to do it like this because later on i want to export the consolidated excel data into my Project database in Access.
Can you help me with this.
P.S. - Any change in .csv will be updated in excel automatically. This linking is very important.
Do you have any such code?
Bookmarks