471,855 Members | 1,058 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,855 software developers and data experts.

Open Excel, Create New Excels

This seems like a simple task. But it's kicking my butt.

I have 1 existing excel file. I want to copy the first 50 rows from
that excel file, and put them in a new excel file. Then I want to get
the next 50 rows of the existing document, and put them in another
brand new excel file. The new excel documents cannot have named column
headers. I want to keep getting 50 rows "chunks" from the existing
file, and putting them into seperate, new excel files. I need to it to
run until there are no more existing rows in the existing excel file
(to the end of the file).


Open exsiting excel file
Copy first 50 rows
Create new excel file
Create new worksheet in the new excel (tab at bottom)
Put the 50 rows in the new excel document
save the new excel document to .xls
Get the next 50 rows of the existing excel document
put them in a brand new xls document
keep doing this until eof of existing excel document
Can anybody point me in the right direction?

- Steve

May 22 '07 #1
0 1816

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Chris | last post: by
10 posts views Thread by Robert Hicks | last post: by
reply views Thread by net guest via DotNetMonster.com | last post: by
reply views Thread by NeoPa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.