Sheet Overflow

  • Thread starter Thread starter Helen
  • Start date Start date
H

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Code for Pasting Sheets 2
Macro to Compile Data from Different Sheets 2
Save record Into master sheet! 1
Macro to copy value in field and insert it into filter 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Find a value in a sheet and replace it with another value if it matches 8
copy a template and fill in data from a single worksheet 1
Run macro from active workbook whose name keeps changing 20

Back
Top