Break down Excel file into multiple Excel files

[Mohkh]

Hello,

I have one large excel file and want to break it down into multiple excel files based on the number of rows.

for example:
The first 16k rows will be saved as excel file No.1
The second 16k rows will be saved as excel file No.2

Could you please help me out by pointing out which function I need to use?

Thanks

[santo_13]

Is it Excel file like xls or xlsx or is it CSV?

If it is csv or txt file, you can use the read delimited spreadsheet function. If it is xls or xlsx, you might need to use the reporting toolkit functions or Excel's activeX APIs.