Creating .ini file from excel using vba for gps co-ordinates

Hi Guys,

i need help in creating an ini file for GPS co-ordinates ($GPRMC format).
Currently in excel i have latitude and longitude below is the attachement:

lat lon.JPG ---- excel file

but need to create an .ini file in the format below:


[GPS Coords]
Coord1=$GPRMC,123519,A,1259.25378,N,7744.20074,E,022.4,084.4,230394,003.1,W*5D
Coord2=$GPRMC,123519,A,1259.2551,N,7744.13588,E,022.4,084.4,230394,003.1,W*63
Coord3=$GPRMC,123519,A,1259.26152,N,7744.13408,E,022.4,084.4,230394,003.1,W*5B
Coord4=$GPRMC,123519,A,1259.2593,N,7744.22726,E,022.4,084.4,230394,003.1,W*69

And in the calculate the checksum which is 5D, 63,5B,69 in examples above.


Pls help me creating vba script for above.

Thanks

X post
https://www.mrexcel.com/forum/excel-...ordinates.html