fortran dll and excel

[mariokaiser]

hello,

i created a fortran dll out of a well running fortran console application.

i am using a subroutine in this dllvia excel-vba - but as soon as i call this subroutine in my vba sourcecode, excel is shut down immediatelywithout any saving...

i know that this is not very precise, but maybe idid some typical mistakes in my fortran routine...?

bye

[mariokaiser]

i am pretty sure that the variables are declared incorrectly.

i want to pass over a twodimensional array:

VBA:

Public z_Out() As Double

ReDim z_Out(1 To 4, 1 To n_Out)

Fortran:

real(8)

, intent(out)::z_Out(4, n_Out)

!DEC$ ATTRIBUTES REFERENCE :: z_Out(4, n_Out)

is that done correctly / what do i have to change???