Can anyone give me some help with a call of DLL in VB/excell?
I receive a runtime error '453' which says can't find dll entry point.
Below came from alt-F11 screen in excell.
Public Declare Sub KEN_2 Lib "C:Program FilesMicrosoft Visual StudioMy Projectsken_2KEN_2.dll" Alias _
"_KEN_2@4" (ByVal I As Integer, ByVal J As Integer)
I = 2
Call KEN_2(I, J)
ActiveCell.Value = J
DLL source looks like below in Fortran.
!DEC$ ATTRIBUTES STDCALL,DLLEXPORT :: KEN_2
!DEC$ ATTRIBUTES ALIAS:'KEN_2' :: KEN_2
!DEC$ ATTRIBUTES REFERENCE :: i,j
j = i + 1
Thanks for the help.