Saturday, December 1, 2012

Plot locations on Google World map by passing Latitude and Longitude

If you want to show/plot your office location/delivery centers on Google World Map. Snapshot below-

Steps to Run
  • Download the file
  • Add color codes and Html name of color in Col F & G(Make sure Color codes are in ascending order like 1 , 2, 3 etc and are in numbers only)
  • Add Latitude and Longitude in Col A & B
  • Add color code in Col C
  • Add text to be displayed in Tool Tip in Col D
  • Click on Update Macro
  • Update the Legend on “Map” sheet manually

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...