A while ago I incorporated the following code into a spreadsheet and it worked well.
Private Declare Function GenIosMapUrl Lib _
"D:\Rob\Offline Docs\Innoprac\FullPoleList\MapsMeGeoMaker.dll" _
(ByVal latit As Double, ByVal longit As Double, ByVal zoom As Double, ByVal locName As String) As String
Public Function iosURL(Latitude As Double, Longitude As Double, zoom As Double, Name As String) As String
Dim URL As String
URL = GenIosMapUrl(Latitude, Longitude, zoom, Left(Name, 30)) 'limit length of name to 20 characters for now
'iosURL = Left(URL, Len(URL) - 1) 'remove trailing chr(0)
iosURL = URL
Then my SSD died so I had to replace it and reinstall Windows 10 Home. This time I put the dll in the root directory, "C:\MapsMeGeoMaker.dll" (and several others to try to resolve) but every time I run it I get the message Run-time error '52': File not found "C:\MapsMeGeoMaker.dll". I've checked the spelling and even run a function to test that the file exists (in case I did something really super-stupid) and the dll is definitely there but the function won't work.
Does anyone know what I might be doing wrong?