HI, I tried to use these code, However, I need the
variable
that can be
shared among different modules and different workbooks.
e.g, I have
written an addin workbook : addin.xla and I declared an
array called
arr1() as double.
then I use this array in other sheet to copy the values
into this array
from another workbook book1,xls and I find that it doesn't
work.

may you help me again? thanks


Desmond
-----Original Message-----

as per my later response....using public variables makes
the adta available to other code modules.
If you want the data vailable some other way, you might
consider saving them to a file using the file OPEN method
for reading/writing, ot better, using the
FileSystemObject to access files.

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
As title.
I want to write a dynamic link library for excel
to store some data in the memory and then can be
recalled from other modules in excel.
i.e use dll to store the Data in memory and recall them
by
calling them.
So, can some help me?
or using macro is also ok.

Thanks
.

.

..