xlsx splitter by rows

[drgkt]

Hi

Can a VBS script take an xlsx file that has more than 65000 rows and create as many target files whose rows number count do not exceed that?

This script should work independent of Excel in windows xp

[alansidman]

You are asking about an .xlsx file which means that you must be using at least XL2007 or later, yet your profile says XL2002. Please clarify and update your profile if you are using a later version.

[drgkt]

I am looking for a vbs script that can run on windows xp which will process an .xlsx file with more than 65000 rows and create as many as needed files with max rows 65000.

This will be done because Excel for xp (with a service pack) can open an .xlsx file via conversion BUT disregards any rows beyond 65536.

It is obvious that this code must stand alone as a .vbs file and not in a workbook module.