When importing a large file into Excel that flows over the limit of one
worksheet, is there a way to have it automatically flow to the next sheet?

We will need a macro to import line by line and keep counting. Once line
number exceeds a preset limit, switch to next sheet please.

Cheers

"Sash" wrote in message
...
When importing a large file into Excel that flows over the limit of one
worksheet, is there a way to have it automatically flow to the next sheet?

Can you point me in the direction of an example of such?

"PY & Associates" wrote:

We will need a macro to import line by line and keep counting. Once line
number exceeds a preset limit, switch to next sheet please.

Cheers

"Sash" wrote in message
...
When importing a large file into Excel that flows over the limit of one
worksheet, is there a way to have it automatically flow to the next sheet?

This is one of THE most faq.
Google with key words "line input" will give you tons of it please.

"Sash" wrote in message
...
Can you point me in the direction of an example of such?

"PY & Associates" wrote:

We will need a macro to import line by line and keep counting. Once line
number exceeds a preset limit, switch to next sheet please.

Cheers

"Sash" wrote in message
...
When importing a large file into Excel that flows over the limit of
one
worksheet, is there a way to have it automatically flow to the next
sheet?

Microsoft has a macro solution that may help:

http://support.microsoft.com/default...;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

I'd just use my favorite text editor and split the data into smaller pieces--and
then import each piece to a new worksheet.

Sash wrote:

When importing a large file into Excel that flows over the limit of one
worksheet, is there a way to have it automatically flow to the next sheet?

--

Dave Peterson