grimreeper
New Member
- Joined
- Feb 12, 2013
- Messages
- 13
Hello All,
I need to copy data from a text file which has a million rows into excel.
The vba code should copy only 50k rows from text file at once into 20 separate sheets in excel workbook so that each sheet has only 50k rows in excel. Any help would be really appreciated.
Thanks,
Grim
I need to copy data from a text file which has a million rows into excel.
The vba code should copy only 50k rows from text file at once into 20 separate sheets in excel workbook so that each sheet has only 50k rows in excel. Any help would be really appreciated.
Thanks,
Grim