How to set a path to a dll in VBA

[PC User]

I'd like to ensure that my code is linking to a dll that I've placed in the same folder as my spreadsheet. What code would I use to do this? This is the code that I'm working with. The dll is swedll32.dll. https://pastebin.com/nfwkHRfA

 

[Jaafar Tribak]

I'd like to ensure that my code is linking to a dll that I've placed in the same folder as my spreadsheet. What code would I use to do this? This is the code that I'm working with. The dll is swedll32.dll. https://pastebin.com/nfwkHRfA

Take a look at the following link yo figure out how Windows searches for dlls :

https://msdn.microsoft.com/en-us/library/7d83bc18.aspx

You can also place the dll file in a folder of your choice but then you would need to fully qualify the dll path in the declare statement... So for example if you place the dll in the C:\Test directory then this is how you should call the swe_calc function :

Private Declare Function swe_calc Lib "[B][COLOR=#ff0000]C:\Test\[/COLOR]swedll32.dll[/B]" Alias "_swe_calc@24" ( _
          ByVal tjd As Double, _
          ByVal ipl As Long, _
          ByVal iflag As Long, _
          ByRef x As Double, _
          ByVal serr As String _
        ) As Long