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.
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 End Function
From novice to tech pro — start learning today.