Hi Board Members,
I need help in creating a Macro which will help me to pull data from Multiple CSV files (text CSV as well as XL CSV, I mean different types of CSV) from a destination folder.
The CSV file names can be stored in a separate sheet as a List. The code has to pickup file names from the list and run the loop to identify the files at Destination, copy the contents in a Workbook. While copying, it will copy to different Worksheets.
Let's say for an example, there is a CVS file named AA, the data from AA file to be copied to the AA sheet/tab in MasterWorkbook. Similarly, the data from AB CSV file to be copied in the AB sheet/tab of the same XL MasterWorkbook.
The List will have the name of Files as AA, AB, etc.
MasterWorkbook can't be changed to accommodate any new feature as it has a different owner. Please help.
Edit: CSV file can come in Text format as well.
I need help in creating a Macro which will help me to pull data from Multiple CSV files (text CSV as well as XL CSV, I mean different types of CSV) from a destination folder.
The CSV file names can be stored in a separate sheet as a List. The code has to pickup file names from the list and run the loop to identify the files at Destination, copy the contents in a Workbook. While copying, it will copy to different Worksheets.
Let's say for an example, there is a CVS file named AA, the data from AA file to be copied to the AA sheet/tab in MasterWorkbook. Similarly, the data from AB CSV file to be copied in the AB sheet/tab of the same XL MasterWorkbook.
The List will have the name of Files as AA, AB, etc.
MasterWorkbook can't be changed to accommodate any new feature as it has a different owner. Please help.
Edit: CSV file can come in Text format as well.
Last edited by a moderator: