Split a file into multiple files

**bkormoski** · 08-11-2009, 03:20 PM

i have a file that is 10,000+ lines and need to break it every 900 lines into a new file. Is there a way in excel to accomplish this?

**ravishankar** · 08-12-2009, 02:53 AM

Hi
Create a sub folder called split990 in C drive and try the following macro codes.

Please Login or Register  to view this content.

Ravi

**bkormoski** · 08-12-2009, 11:25 AM

Ravi,

Thanks for the code - One more thing is it possable to have the header in Line 1 copied to each new file in line one?

**ravishankar** · 08-13-2009, 10:09 AM

HI
try the following modification. Change ski.xls to the current file name. A1:Z1 to the range of header length.

Please Login or Register  to view this content.

Ravi

**bkormoski** · 08-13-2009, 10:24 AM

That is fantastic - THANKS

**bkormoski** · 09-10-2009, 01:30 PM

where in the macro should I put code to rename "Sheet 1" on each file it saves?

**ravishankar** · 09-11-2009, 12:14 AM

Hi
insert the code in bold as shown

Please Login or Register  to view this content.

Ravi

**bkormoski** · 09-11-2009, 08:36 AM

Thank you very much

**phenicie** · 01-09-2012, 03:02 PM

ravishankar this is amazing. I appreciate your time with this, it is going to help me tremendously. Are you aware of anyway to name these outputs.I need to have a internal file number that just has an auto incrementing file number?

**TMS** · 01-09-2012, 03:38 PM

@phenicie

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Regards, TMS

**royUK** · 01-09-2012, 03:38 PM

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.