Hi all member forum.
I worked in one of the main private banks in my country,I want to use excel macro to simplify my work, because I am still learning about this Excel VBA, I want to ask something :
1. How and what yah VBA syntax we use if we want to process the data from csv file and line number of the file exceeds the capacity Ms.Excel (more than 1,500,000). I want to break down the contents of the file into multiple sheets. to the number of rows excel currently 1,048,576, now my data exceeds the number of rows. I want to move the rest of the excess data sheet to the next row in another sheet (using macros). please enlightenment ...

2. How and what VBA syntax we can use if we want to process the data from csv file where there are multiple csv files (each file has a number of different lines) and the files we will combine into 1 in the excel sheet. exmple : I have 3 csv files, three files I want to combine into one sheet in Excel using macros.

please anyone can help me to this case..
thank you.