call cobol Dll in VBA

[Ronald_yoh]

hi there,

anyone knows how to call cobol DLL in VBA?

Below is the code:
Public Declare Function HELLOWORLD Lib "hELLOWORLD.DLL" () As String

In the immdiate window I type "?Helloworld" and I keep getting an error 53: file not found.

I put the dll file in the windows/system32.

It works if I created C dll (is there something special with cobol dll?)

any idea? - HELPPPPP.....

Thanks
R

[OBP]

Have you set a VBA Editor "Library Reference" to the dll file?

[Ronald_yoh]

hey dude.. don't worry... i just fixed the bug from the cobol dll..

thanks again...

Ta