469,646 Members | 1,567 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Open Excel File, Create New Excel Documents

For the life of me, I cannot get this ...

I have 1 excel document. I want to open that document and copy the
first 50 rows to a new document. Then get the next 50 rows and copy
those to a brand new document. I want to do this until the end of the
Excel file.


Open Excel1.
Copy first 50 rows
create new excel
create new worksheet (tabs at bottom of excel)
paste those 50 rows in that worksheet
save the new excel document
get next 50 rows
do same thing
until EOF.

Can anybody point me in the right direction? This seems like such a
simple task, and yet it's killing me.

P.S. The new excel file cannot have named header rows.

- Steve

May 22 '07 #1
0 1698

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Daniel | last post: by
21 posts views Thread by bobh | last post: by
reply views Thread by kennedystephen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.