External dll as base for user defined vb functions

[#1]

Hello all,

I have an external dll file that contains some functions that I need to use to transform data. I do not have the functions available elsewhere. I have succesfully used this DLL file in Excel where you would use a module like this:

Declare Sub Lambert08ToLambert72 Lib "C:\Program Files\NGI\WINDOWS\32bits\ETRS89_LAMBERT_UTM_32bits.dll" (ByVal xi As Double, ByVal yi As Double, ByVal Hi As Double, ByRef xo As Double, ByRef yo As Double, ByRef Ho As Double)


Function NGI_Lambert08ToLambert72(x As Double, y As Double) As Variant
    Dim xo, yo, Ho As Double
    Call Lambert08ToLambert72(x, y, 100, xo, yo, Ho)
    NGI_Lambert08ToLambert72 = Array(xo, yo)
End Function

Is there a way to do the same in QlikView?

Thanks

Mathias

[#2]

I believe, you can create the USER defined functions and call this functions just like other predefined functions.

[#3]

Thank you dathu for your suggestion but with the script above i get an error when i leave the macro module. It seems qlikview is unable to recognise the first line.

[#4]

No other ideas community?

[jhamard]

It's possible !

Look at my post : Calling a DLL function in my QV script ...

🙂