Inserting large amounts of data with VBScript...
 

Hi!
I'm pretty new to Excel programming and to VBScript.
What I've got is a script that takes value from another application
and inserts them into Excel. This works fine, except for when it
gets Data in a particularly large array (8606 rows, 44 columns).
Here the script fails.
The function runswell on smaller data sets.
Am I stumbling over an internal limit of Excel here?

Lots of Greetings!
Volker

Inserting large amounts of data with VBScript...
 

Volker,

I'm not sure why your code would bomb at (8606,44). Excel has a limitation
of (65536,256). There are a couple of ways to get around having too many
rows. One way is to create a new sheet in VBA when your data input reaches
the last cell. The other, for single columns of data, moves the active cell
to the first row of the next column for input. If you're interested in
either of these let me know and I'll post the script.

Mike

"Volker Hetzer" wrote:

Hi!
I'm pretty new to Excel programming and to VBScript.
What I've got is a script that takes value from another application
and inserts them into Excel. This works fine, except for when it
gets Data in a particularly large array (8606 rows, 44 columns).
Here the script fails.
The function runswell on smaller data sets.
Am I stumbling over an internal limit of Excel here?

Lots of Greetings!
Volker