Is there a maximum array size one needs to deal with in PB8? I tinkered with compiling a DIM statement defining a string array and kept bumping it up until it seemed unreasonably large and PB never did complain that the array would be too large to manage.
(e.g. I DIMed a 3 dimensional string array 2,000 elements on a side - something like 8,000GB of data if I didn't slip a dismal point. And a lot bigger than my computer is.)
The problem I'm really considering is to move an entire large Excel workbook into PB (via VBA call & DLL) to do some intensive calculation and then back to Excel with the result. This would be as an alternative to moving individual sheets to PB repeatedly. I was trying to understand how large an array PB could reasonably handle.
Thanks.
Bill
(e.g. I DIMed a 3 dimensional string array 2,000 elements on a side - something like 8,000GB of data if I didn't slip a dismal point. And a lot bigger than my computer is.)
The problem I'm really considering is to move an entire large Excel workbook into PB (via VBA call & DLL) to do some intensive calculation and then back to Excel with the result. This would be as an alternative to moving individual sheets to PB repeatedly. I was trying to understand how large an array PB could reasonably handle.
Thanks.
Bill
Comment