How to split .xlsx by lines?

Question

Macros

There is a large file with more than 27,000 lines. How to split it into the same .xlsx files, but let's say 1000 lines each?

Answer 1

Write a script in VBA, though I don’t know if it can save to a separate file, but I’m almost sure that it can. Or write a small application, for example, in C ++, which, through COM, will open the source file and cut it into small ones.

Answer 2

second link in google programmersforum.ru/showthread.php?t=88004