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.
So...
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.
Thanks,
- Steve
