G
Gaza
Hi
I have a big 3 dimensions array of data (integers).
I want to load this data the first time the workbook will run so i could use it later on in functions/formulas that I'll create in VB.
example:
Dim arr(10,10,10) As Integer
Public Function GetData(x,y,z) As Integer
GetData = arr(x,y,z)
End Function
How do I load the data into the arr(10,10,10) array (let say the data is in other excel file or in one of the sheets in the same workbook)
I don't want to load the data every time I call the function from the worksheet - it is big data base
Thanks
Gaza
I have a big 3 dimensions array of data (integers).
I want to load this data the first time the workbook will run so i could use it later on in functions/formulas that I'll create in VB.
example:
Dim arr(10,10,10) As Integer
Public Function GetData(x,y,z) As Integer
GetData = arr(x,y,z)
End Function
How do I load the data into the arr(10,10,10) array (let say the data is in other excel file or in one of the sheets in the same workbook)
I don't want to load the data every time I call the function from the worksheet - it is big data base
Thanks
Gaza