Creating Smaller Lists from a Big List

I have a file with about 10,000 entries that I need to break into separate files of no more than 100 lines each. I also need to spit them out in CSV with double quotes ala this macro:

http://www.markinns.com/articles/ful..._double_quotes

Is there a way to do this with scripting? (I am a VBA and excel novice).

Thanks.

try

Please Login or Register  to view this content.

Thanks for the fast response but both macros hang up on the file. I've attached a test file that might help explain the format. Thanks.

test_template.xls

I was able to get JBeaucaire script to work kind of. I have a file with 8700 or so rows. When the macro runs it asks How many rows to export per file? which is defaulted at 10. When I change it to 100 I still get 870 data files that seem to have 90 rows from the previous one. Am I doing something wrong?

Hung up?

try this one

Please Login or Register  to view this content.

@jindon

Runtime error 70

It doesnt like this line:

Open CreateObject("WScript.Shell").Specialfolders("desktop") & "\testLast.csv" For Output As #1