{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Geocoding"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Geocoding","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,2,21,3],[0,0,0,7],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[11,2,11,3]]}
["Geocoding Using VBA & Google API"]
[]
[null,"Example","Address","Coordinates","Latitude","Longitude","Notes"]
[null,1,"White Tower of Thessaloniki",{"$f":"GetCoordinates(C4)","v":"40.6264463, 22.9484257"},"-","-","The most known monument in Thessaloniki (the White Tower)."]
[null,2,"Egnatia 154, Thessaloniki, 54636","-",{"$f":"GetLatitude(C5)","v":40.627663699999999},{"$f":"GetLongitude(C5)","v":22.955075799999999},"Aristotle University address - using the separate functions."]
[null,3,"Toledo, Ohio",{"$f":"GetCoordinates(C6)","v":"41.6528052, -83.5378674"},"-","-","City in Ohio - the function returns the FIRST OCCURRENCE."]
[null,4,"Toledo, Spain",{"$f":"GetCoordinates(C7)","v":"39.8628316, -4.0273231"},"-","-","Note the difference!"]
[null,5,"58400, Greece","-",{"$f":"GetLatitude(C8)","v":40.971517800000001},{"$f":"GetLongitude(C8)","v":22.0586722},"Search through a postal code - using the separate functions."]
[]
[]
[]
[null,null,"ALT + F11 to view the VBA code."]
[]
[]
[]
[null,null,"Geocoding Using VBA & Google API"]
[null,null,"© Christos Samaras"]
[null,null,"Mechanical Engineer"]
[null,null,"tel.: +306973513308"]
[null,null,"e-mail: xristos.samaras@gmail.com"]
[null,null,"site: https://www.myengineeringworld.net"]
[null,null,"Thessaloniki, Greece 12/06/2014"]