I have an application that creates a CSV data file. Most of the people I deal with want to use excel to view the files and create a chart or two. My issue lies in that the text files often excede 65554 lines which is excels maximum and excel never loads the entire file.

Is there a way to write some vba code that will split the file up into a series of files with the number of lines that the user specifies. The original file is named something like data001.csv and I want the new files to be data001_001.csv, data001_002.csv etc etc.