Help!Call dll compiled by interl fortran2013 from Excel VBA

[Luo__seamon]

I am trying to pass an 2-D array from an Excel VBA code to a FORTRAN dll which I made with the Intel FORTRAN 2013 compiler in Visual Studio 2013. I have tried in VB.net and C# ,and it works well. But when I call the dll from Excel VBA, it always tell me thay overflow.

The attachment includs an excel file and fortran code. Maybe the Directory need to be change to your own.

Any help would be appreciated.

[gib]

It is outside my experience, but you should look at this thread:

https://software.intel.com/en-us/forums/intel-visual-fortran-compiler-for-windows/topic/283267

Note that multidimensional arrays require special treatment (or did in 2011, anyway).  Perhaps it would be easier to restructure your code to use 1D arrays.

[Luo__seamon]

gib,

Thanks for your response. I have amended my fortran code according to the link you gave to me,and it really  works,and also thank steve.