When you run the macro, you can easily track the status from the status bar of your Excel application. Please make sure that your machine has Internet explorer. Value on Columns A through Column D is input and the output i.e., Latitude and Longitude gets displayed on Columns E and F Let’s make it functionalĬopy the script into a new module and attach the macro to the button on the Sheet. At Row 5, starting from Column A, add these as headers These 3 values will be used for all rows in the Excel sheet. Let’s Prepare the GUIĪs shown in the image, leave top 4 rows of the excel sheet for holding Map Datum, Zone and Hemisphere. Otherwise, if you want to DIY, you can read the contents below. If you want to start to use the software as soon as possible, then you can: A Universal Transverse Mercator (UTM) coordinate is made up of a zone number, an easting, a northing and a hemisphere (N/S). With UTM converter you can easily convert UTM coordinates into Latitude and Longitude values.
0 Comments
Leave a Reply. |