VBA C++ Dll

charleslliu · November 16th, 2006, 7:59 pm

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 VBA, I got the error message of "Run time error '28', out of stack space"anyone knows how to solve this memory issue? thanks ( I did have a successful run of an interest rate curve up to 8 years, i.e. in C++ dll, I have several arrays with the size of [96][96])

fkato · November 17th, 2006, 2:58 am

Excel 97 and up have a stack limit of about 44K. So don't use auto arrays, use the heap (malloc, new) to allocate data. Besides that, depending on the compiler, arrays of double allocated in the stack (auto) may not be 8-byte aligned.fkato.

DominicConnor · November 17th, 2006, 11:43 am

Wanton Plug...The CQF C++ course will do this stuff...What you need to do is drop in the DangerArray class in my lecture notes attached to this post. For your particular issue, I'd make sure that I was 100% on ByRef and ByVal

charleslliu · November 17th, 2006, 2:58 pm

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

phenomenologist · November 18th, 2006, 8:02 pm

The xl8.zip page is not found, btw:-(

DominicConnor · November 20th, 2006, 7:39 pm

Seems to be a bug in the system. PM me with your email...

maccc · November 25th, 2006, 6:38 am

hi DCFC, I am also interested in your notes to compile dll for VBA! Could you send me your full version?