Northing, Eastings to Longitude, Latitude

[UncleFredo]

Hi guys,

I'm relatively new to Google Earth. I am currently trying to change Northings and Eastings (from GIS data) into Latitiude/Longitude for exporting my CSV file into KML.

Currently I have VBA code (also kinda new to) that takes a description and coordinates and converts it so a KML file, which works. However, the coordinates do seem to be wrong.

I'm no mathematician, and although I understand the theory, I can't seem to code in VBA to allow the coordinate transform correctly. I must be doing something wrong.

Does anyone have an guidance/VBA code for converting Northings and Easting? Also, all entries are UK based ones, so I think you need to use the Airy1830 ellipsoid - I'm unsure. Any help would be appreciated!

Cheers

[barryhunter]

See here here for a excel spreadsheet that can do the conversions, the macros are vbscript so should just copy/paste.
See also here, for php and JS source code based on the same vbscript, it shows how to use it 'standalone'

Otherwise I have a webservice here, that can do the conversion for you via a simple remote call. It might not be effienct but might be simpler if have problems. I know from settting up this site how complex the the coordinate transformations are and luckily I found example codes like this...