Sheet Overflow

[Helen]

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

 

[Frank Kabel]

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