cancel
Showing results for 
Search instead for 
Did you mean: 

calling STBLLIB.DLL functions from Visual Basic for Applications

plunenburg9
Associate
Posted on December 21, 2009 at 17:52

calling STBLLIB.DLL functions from Visual Basic for Applications

1 REPLY 1
plunenburg9
Associate
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!