Splitting Excel File Using VB

Question

I have an excel worksheet that produces data into another worksheet. After this I export from the worksheet into a csv format. I need to be able to split the data every 250 rows into a new file regardless of the information contained. I'm using VB for the coding in this.

Any help greatly appreciated.

Thanks

Answer 1

If your spreadsheet is XLSX Office 2007, you can look at the Open XML Format SDK.

Answer 2

Thanks for the suggestion but unfortunately I'm using Excel 2003.