I wrote a dll in C++ to be called from Excel VBA. Two main problem arise…
1. Within the vba code there is the call to the dll. Well, after the execution of this line of code, I get an overflow error, I enter the debug mode and the it works fine again. It seems that the VBA code doesn’t wait for the dll to finish its computation.
2. This dll routine is called thousands of time and I notice during the execution, that the memory allocation (from task manager) grow awfully, till excel crashes since there’s no more memory available.
With other fortran dll, all this mess doesn’t happen!
Do you know where the problems can lie?
Thank you very much!!