469,601 Members | 2,039 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

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).

So...

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?

Thanks,
- Steve

May 22 '07 #1
0 1747

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
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.