472,146 Members | 1,390 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

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

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 1783

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
reply views Thread by Saiars | last post: by
reply views Thread by leo001 | 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.