aniketjha21
New Member
- Joined
- May 13, 2016
- Messages
- 5
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:
---- 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
Aniket
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:

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
Aniket