calling STBLLIB.DLL functions from Visual Basic for Applications

plunenburg9 · ‎2009-12-21

Posted on December 21, 2009 at 17:52

plunenburg9 · ‎2011-05-17

Posted on May 17, 2011 at 13:35

Hi,

I would like to call functions provided by STBLLIB.DLL from Visual Basic for Applications. However, when calling functions that require parameters VBA consistently returns error message 49: ''Bad DLL calling convention.'' I think the data type of the parameters is wrong (e.g. using Long when Integer is expected).

In the msdn library for Microsoft Office XP Developer is stated:

''In recent versions, however, VBA converts all integer values to type Long, even if they are declared as type Integer.''

Does anyone know a way around this?

Thanks!