Outputting VB Arrays to Excel: Size Limit?

[Christopher.Franklin]

I am currently outputting arrays of data to Excel, this all worked fine when outputting an array of size 12*381 (4572 elements), but fails when the arrays size is upped to 18 * 381 (6858 elements). Does anyone know what the output limit to Excel is?

{I have tried MSDN for several hours but drawn a total blank on the limit}.

Details:

VB Code:
.Range([Start Cell], [End Cell]).Value = ARRAY

Where ARRAY is an array exactly matching the Excel range in size. (This has been checked).

Software Versions:
Visual Basic 5 (SP2)
Excel 7.0a


Thanks for any help

I know that there is a row limit to Excell (16k) but I didn't realize that there was a cell limit. It could also be that there is a limit to the IMPORT function that doesn't exist in the native.

Possibly, arrays carry overhead that would cause the damn thing to blow up.

Could you possibly have a screwed-up installation of Excell? Try to output an array that blows up Excell, to a text file and then import it. This is not suggested as a workaround, simply to eliminate a possible lockpoint.

Good Luck
DerFarm

[Christopher.Franklin]

This shouldn't really be a messed up version of Excel, as the failure occurs on several different machines and all show the same error. These machines have been installed at different times and potentially by different procedures.

The code doesn't require using the "Import" function. The VB uses a reference to a worksheet on an Excel object, created at run-time using the create object. Data is "put" directly on the "Value" property of the range object.

Thanks for help so far

Chris