kyGeoTools - Kentucky Geographic Tools ActiveX Component

kyGeoTools zipped file | documentation | version changes

Use kyGeoTools V3.23 to convert coordinates between...

• Datums
  • NAD27
  • NAD83
• Projections
  • Kentucky State Plane Coordinates (Single/North/South zone)
  • adjacent state State Plane Coordines (MO, IL, IN, OH, WV, VA, TN)
  • UTM 16/17
  • Carter Coordinates
  • geographic
• Units
  • decimal degrees
  • USft, international ft, miles
  • meters, kilometers

To use kyGeoTools with MS EXCEL...

1. Download and unzip the KyGeoTools.zip file.
2. Be sure to uninstall previous version prior to installing an updated version.
3. Install kyGeoTools by double clicking the unzipped Setup.exe file.
4. Open Excel and do the following:
   • Open the VBA Editor by pressing [alt-F11] or by clicking on Tools | Macro | Visual Basic Editor pull down option.
   • In the VBA Editor, Reference the kyGeoTools ActiveX component via the Tools | References pull down option and scroll down to the KyGeoTools item. If an existing spreadsheet indicates that an existing instance KyGeoTools is "Missing", click the Browse button and open Windows/System32 and you should select KyGeoTools.dll in that directory. Click OK to close the dialog.
   • Create a function for the spreadsheet using the VB editor, and call it as you would other excel functions.
   • It is probably easiest to use an example as a template, kyGeoTools_Example.xls.
     You may need to click "enable Macros" for it to load on your system.