Divide Database Into Smaller Files with 200 lines each

[Gamermatt]

Hello,

I have a very large database, and I need to divide it into smaller files of 200 lines each. So, every 200 lines there should be a new file saved. Is there a way to automate this, and save each smaller database as a csv file?

Matt

 

[Gerald Higgins]

Do you want to do this whole task just once, or regularly ?

 

[Gamermatt]

Just once

 

[Gerald Higgins]

How are you going to name the individual csv files ?

 

[Gamermatt]

It doesnt really matter... 1.csv, 2.csv, 3.csv, 4.csv, etc would work fine

 

[Gerald Higgins]

OK.

I think the task can be broken down into 3 chunks.

1) Moving the top 200 lines into a separate worksheet, and saving that worksheet by itself as a *.csv file.

2) Automating the naming of the file so that it increments in the way you have described.

3) Looping through (1) and (2) until you get to the bottom of your data, then stopping.

Part 1 is easy, you should get workable code by using the macro recorder while you do the job manually.

Part 2 is do-able, but a little beyond me right now, but try searching the board using terms like vba, file-name, and so on.
For example, I found this thread, which looks like it might be useful (though I haven't tested it myself).
http://www.mrexcel.com/forum/showthread.php?t=229446&highlight=vba+increment+file-name

This thread also deals with part (3).