Creating Objects in excel memory

[Yves]

Hi, I am trying to do the following ( wether by programing something in vba, or by finding some xll addin that would allow me to do it)

Say I have an array of data in excel, 10*10 for example.
I would like to create an object in memory called Array1 for example
that would be acessible anywehere in excel. The function would look like
=CreateObject(ObjectName,Array)
other functions like =DisplayObject(ObejctName) would return the object
in an array on the spreadheet
This would be useful to mnaipulate large number of different array without having to worry about their location on the sheet.
I do not think it is easy to implement in vba but some xll addin must exist somewhere that allow to do that.

many thanks

 

[Norie]

What exactly are you trying to achieve?

 

[Yves]

Hi, what i am trying to achieve is a way of having a clean way of dealing with large array of data. say you have 10 arrays of 100*100 datas, i have a library of function that allow me to sort, filter, and process those data.
Having those array in memory rather of the spreadhseet makes thing much easier. those arrays are typically text files that would be loaded directly into object and would never appear at any point on the spreasheet. Abit in same way that matlab works ( don't know if you know this application).
thx