||I have been working with two layers of point data and trying to find the distance between all combinations of points on each layer. I received a VBA script from someone else and was able to modify it to make it find the distance but the value returned in the finished table is in decimal degrees, same units as the base map.
I have tried to rest the base map so distances are measured in mile, meters, etc by setting the base layer projection before loading the point data layers (each point identified by lat/long) and the map is displayed correctly, the map units are reported in meters and distances are measured in meters with the measure tool. However after running the VBA macro, the value returned is still in decimal degrees.
Is there a way to set the map unit so that it reports the right units (units I want) after running the macro?
Is there an easy way to convert decimal degrees to feet, meters, miles, kilometers (something I understand) outside of ArcMap?
Any help would be appreciated. Thanks in advance.