Hello,
Here's an example of opening a location in Google Earth directly from MS Excel using a VBA macro.
The spreadsheet contains a data sheet - wth names, lan/long pairs and descriptions - and a control sheet with the kml code and file details. Click on the "
Open in GE" link on a row to open those co-ordinates in directly in GE.
Make sure that the "temp dir" value is set to a suitable temporary directory and that the path to the GE executable is correct (this will probably be different to the default if you are using GE Pro; I've put little error handling in so the macro will just break if it's not right).
See also the Excel to KML converter, which creates a kml file for all locations in a spreadsheet:
http://bbs.keyhole.com/ubb/showthreaded.php/Cat/0/Number/613667Disclaimer: This is provided 'as is' with no support or guarantees etc. Care should be taken opening any file including a macro - I've no reason to suspect that it contains a virus (I should hope not - that means my PC is infected!) but I still suggest scanning with an anti-virus tool just in case.![](https://ci4.googleusercontent.com/proxy/7lVLd9jWMgn-72zDpH-1IFKfplCFZTJeGNjeAqqKCDKVw-5FC7AEg2B8vC5w9CcCXlMoYFwWnSEq=s0-d-e1-ft#http:///ubb/images/graemlins/smile.gif)
Simon.