Hello all,

I want to use a DLL writen in Pascal to provide functions for a Excel VBA code:

The example code of my DLL is:
library CE;
{$mode objfpc}
uses
Sysutils;
function level(x1, x2: integer): integer; cdecl; export;
begin
result := x1 + 2*x2;
end;
exports
level name 'level';
end.

In VBA, I did the following code:

Public Declare Function dlevel Lib "CE" Alias "level" (ByVal x1 As Integer, ByVal x2 As Integer) As Integer

Function nivel(ByVal x1 As Integer, ByVal x2 As Integer) As Integer nivel = dlevel(x1, x2)
End Function

In the sheet, I did:

=nivel(2;5)

And I got:
#value

I really don't know what to do. Seemlngly, VBA code is correct. I don't know so much about DLLs, would be possible to have a mistake in my Pascal code?

Does someone have any idea?

Best regards,

If you're on windows the declaration "cdecl" should be "stdcall".

HTH,
Marc

The problem is solved. Actually, I didn't know that, in my Linux, sharable libraries are only accessible from /usr/lib.

As I was trying to access a lib in another directory, Libreoffice was not able to find it.

Regards,

Luciano

2015-12-11 17:15 GMT-02:00, luciano de souza :

That's more of a limitation of the application program than anything else. I've definitely got a Pascal program calling a Pascal-written .so from the same directory that contains the main binary, and in most cases it's possible to tailor the path using- among other things- LD_LIBRARY_PATH.