thanks everyone, last night I did solve the problem by declaring function variables as static. a hint i got from Dalton's bookcheers

<t>Hi, Could anyone let me how to solve my problem? thanks in advance1) In excel, I have an array of 8 elements ( from 6month up to 10 years interest rate curve) 2) In C++ Dll, in order to build a binomial tree, I create several arrays with the size of [120][120]apparently, when I called Dll from VB...

thanks DCFC, thanks tibbarsorry for my late response. I have been away for the last two days. for sure, I will try boundchecker. my actual program is too long, I will try to set up a small program with same idea to see whether it works or not. If not, I will post it here.thanks for your help

<t>anyone knows what is going on with this problem? thanks in advance1. in C++ Dll, a column vector with 60 elements works fine( I can call from excel) ; after I enlarge it into 120, it still compile in C++2. when I called this dll from excel, I got a error message says " run time check failure # 2,...

thanks, I will follow your direction, but on the other hand, for some reason, I couldn't open your attachment after I clicked on it. The error message I got is the web address could not be found. could you please do it again? thank you very much

<t>does anyone know why the VBA switch rows and columns for a matrix after I pull the matrix from dll?for example, I have a matrix result[3][20] in dll, after I pull it from, and listed it in excel worksheet by VBA, I have to treat this matrix as result(20,3), somewhere is wrong, could someone let m...

<t>thanks, this is how i did it in VBA, I haveDim result(2, 19) As Double Call Compute(Income(0), Hour, charles(0), result(0, 0))For i = 1 To 3 // this is how I output my result, I only list one row from dll Cells(i, 8) = result(i - 1, 0)Next i// the result should show 0,0,0, instead I got 0,1,2. as...

<t>I am still not convinced, just a simple example to further explain what have happened to mein dll, I have matrix result[2][5]1 1 1 1 12 2 2 2 2when I transfer it to excel in VBA, I have to think the matrix result in this way result(5,2) and list the matrix in this way in excel worksheet1 2 1 21 2...

<t>does anyone know why this could happen in my experience with excel and dll?there is a matrix in dll, for example result[20][3], when I output this matrix in excel it becomes result(3,20). A switch of rows and columns happened in excel. It has nothing to do with the way of how I listed my data ( i...

thanks Alvin, I tried "excel.Workbooks.Open" function before and found out it is not user friendly. The problem I am facing is how to load data from 4 excel files and each of them has 65,500 rows.

thanks gallag, much appreciated

thanks, definitely will try

<t>many thanks everyone, the problem I am facing is to pull information (around 100 rows based on what kind of info I want) from 4 excel files and each of them has more than 65,000 rows. Then I have to dump selected info into another excel file which is the template. It looks like ADO is not the cho...

could anyone let me know ------------- 'how to access more than 2 excel files at the same time with VBA ADO?' thanks lot