I am working in Access 2002, specifically VBA.
I have a custom DLL that has functions I need to call. I did not write the DLL and only know the functions that the provider told me I can call. For example:
I have this line in a public code module
Public Declare Function OpenDrawer Lib "MSPOS_USB.dll" (ByVal DeviceHandle As Long) As Integer
I call the function like this, result = OpenDrawer(DrawerHandle).
Is there a way, in the declaration, to replace the value in the strings dynamically? Instead of "MSPOS_USB.dll" I would like to modify this value in runtime. I tried using a string variable and it will not work.