how to write dynamic link library for excel to use?
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 . . .. |
All times are GMT +1. The time now is 03:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com