I'm not sure whether this is possible but I want to create a macro
that will import data until a sheet is full and thgen open the next
sheet and continue. It seems to me that the Excel cells are themselves
constricted by integer values as the program will only process data up
to 32000 lines or so. Is there any way of changing that capability to
a long? Are there any ways of automating the transfer and processing
of large data files?

Many thanks,
Helen

Hi Helen
as an alternative for a macro solution:
- open the import data with a text editor of your chiose
- split the data within this text editor to smaller chungs
(e.g. 60000 rows each)
- import these splitted data

-----Original Message-----
I'm not sure whether this is possible but I want to
create a macro
that will import data until a sheet is full and thgen
open the next
sheet and continue. It seems to me that the Excel cells
are themselves
constricted by integer values as the program will only
process data up
to 32000 lines or so. Is there any way of changing that
capability to
a long? Are there any ways of automating the transfer and
processing
of large data files?

Many thanks,
Helen
.