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

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:

552003d1513251759-creating-ini-file-from-excel-using-vba-for-gps-co-ordinates-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
Aniket
 
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.
 
Upvote 0

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Thanks for the advice.

I have completed the 75% problem with the help of labview, now for the rest 25% i still need the ini file from which co-ordinates to be read. Below is the format of ini file :
[GPS Coords]
Coord1=2226.575,11955.982
Coord2=2226.583,11955.983
Coord3=2226.586,11955.985
Coord4=2226.679,11956.015
Coord5=2226.683,11956.017
Coord6=2226.687,11956.018

Also, below is the excel file from where co-ordinates needs to be extracted (excel file) :

[TABLE="class: grid, width: 221"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Latitude[/TD]
[TD]Longitude[/TD]
[/TR]
[TR]
[TD="align: right"]1259.756352[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.761776[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.7672[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.772624[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.778048[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.783472[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.78889[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.794314[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.799738[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.805162[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.810586[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.81601[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.821434[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.826858[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.832282[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.837706[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.84313[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.848548[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.853972[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.859396[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.86482[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.870244[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.875668[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.881092[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.886516[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.89194[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.897364[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.902788[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.908206[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.91363[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.919054[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.924478[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.929902[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.935326[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.94075[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.946174[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.951598[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.957022[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.962446[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.967864[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.973288[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.978712[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.984136[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.98956[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1259.994984[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.000408[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.005832[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.011256[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.01668[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.022104[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.027528[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.032946[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.03837[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.043794[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.049218[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.054642[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.060066[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.06549[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.070914[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.076338[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.081762[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.087186[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.09261[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.098034[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.103458[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.108882[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.1143[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.119724[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.125148[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.130572[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.135996[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.14142[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.146844[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.152268[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.157692[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.163116[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.16854[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.173958[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.179382[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.184806[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.19023[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.195654[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.201078[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.206502[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.211926[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.21735[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.222774[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.228198[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.233616[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.23904[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.244464[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.249888[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.255312[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.260736[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.26616[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.271584[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.277008[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.282432[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.287856[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.293274[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.298698[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.304122[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.309546[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.31497[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.320394[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.325818[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.331242[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.336666[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.34209[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.347514[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.352932[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.358356[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.36378[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.369204[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.374628[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.380052[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.385476[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.3909[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.396324[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.401748[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.407172[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.412596[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.41802[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.423444[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.428868[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.434292[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.43971[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.445134[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.450558[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.455982[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.461406[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.46683[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.472254[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.477678[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.483102[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.488526[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.49395[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.499368[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.504792[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.510216[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.51564[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.521064[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.526488[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.531912[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.537336[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.54276[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.548184[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.553608[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.559026[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.56445[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.569874[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.575298[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.580722[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.586146[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.59157[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.596994[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.602418[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.607842[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.613266[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.618684[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.624108[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.629532[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.634956[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.64038[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.645804[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.651228[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.656652[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.662076[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.6675[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.672924[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.678342[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.683766[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.68919[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.694614[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.700038[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.705462[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.710886[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.71631[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.721734[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.727158[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.732582[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.738006[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.74343[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.748854[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.754278[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.759702[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.76512[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.770544[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.775968[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.781392[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.786816[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.79224[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.797664[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.803088[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.808512[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.813936[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.81936[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.824778[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.830202[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.835626[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.84105[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.846474[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.851898[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.857322[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.862746[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.86817[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.873594[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.879018[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.884436[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.88986[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.895284[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.900708[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.906132[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.911556[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.91698[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.922404[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.927828[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.933252[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.938676[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.944094[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.949518[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.954942[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.960366[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.96579[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.971214[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.976638[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.982062[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.987486[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.99291[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1300.998334[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.003752[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.009176[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.0146[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.020024[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.025448[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.030872[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.036296[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.04172[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.047144[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.052568[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.057992[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.063416[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.06884[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.074264[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.079688[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.085112[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.09053[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.095954[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.101378[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.106802[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.112226[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.11765[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.123074[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.128498[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.133922[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.139346[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.14477[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.150188[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.155612[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.161036[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.16646[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.171884[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.177308[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.182732[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.188156[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.19358[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.199004[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.204428[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.209846[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.21527[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.220694[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.226118[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.231542[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.236966[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.24239[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.247814[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.253238[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.258662[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.264086[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.269504[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.274928[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.280352[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.285776[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.2912[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.296624[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.302048[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.307472[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.312896[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.31832[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.323744[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.329162[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.334586[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.34001[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.345434[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.350858[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.356282[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.361706[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.36713[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.372554[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.377978[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
[TR]
[TD="align: right"]1301.383402[/TD]
[TD="align: right"]7743.193616[/TD]
[/TR]
</tbody>[/TABLE]

This is the final piece of SW i need to make my simulator complete.

Thanks
Aniket
 
Upvote 0
Try this. I assumed that was Column A and B. Change as necessary

Code:
Sub SaveINIfile()
Dim x, r As Long
x = Application.GetSaveAsFilename(fileFilter:="INI Files (*.ini), *.ini")
If x = False Then Exit Sub
Open x For Output As [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] 
Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] , "[GPS Coords]"
For r = 2 To Range("A" & Rows.Count).End(xlUp).Row
    Print [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] , "Coord" & r - 1 & "=" & Cells(r, "A") & "," & Cells(r, "B")
Next
Close [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1]#1[/URL] 
End Sub
 
Upvote 0
Try this. I assumed that was Column A and B. Change as necessary

Code:
Sub SaveINIfile()
Dim x, r As Long
x = Application.GetSaveAsFilename(fileFilter:="INI Files (*.ini), *.ini")
If x = False Then Exit Sub
Open x For Output As [URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1"]#1[/URL] 
Print [URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1"]#1[/URL] , "[GPS Coords]"
For r = 2 To Range("A" & Rows.Count).End(xlUp).Row
    Print [URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1"]#1[/URL] , "Coord" & r - 1 & "=" & Cells(r, "A") & "," & Cells(r, "B")
Next
Close [URL="https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=1"]#1[/URL] 
End Sub


Thanks a lot Scott, it works like a charm.
I integrated my D.d to DM.m macro conversion with yours, and result was as per my expectation.

Thanks again.
Aniket
 
Upvote 0

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top