[Help] Open a huge csv then save it into XLSX with every 1M row split into different worksheets

[SevenDP]

Hi Mr Excel Expert,
Please help ...
I have huge CSV file with about 4 Million rows.
I need macro to open that CSV then split it every 1 Million rows into different worksheets but still in one XLSX file.
So with 4M rows the result is one file XLSX with 4 worksheets each got 1M rows.
Because XLSX's worksheets only support about 1 Million rows.

Thanks in advance

 

[SevenDP]

Comment out the lines that have TextToColumns and re-run. This will see if the code will at least put in all of the data into the cells. If it works, you can go back and manually convert to columns.

Hi bro

Sorry for long reply ....
Your solution works !
thank you so much Mr Excel Expert !