程序要求
鼠标选中一些区域,每一行选中的均为站点名称经度纬度的顺序,根据选中的区域信息建立kml文件,并同时打开
操作步骤
(1) 按照程序要求,在表格中选中站点名称经度和纬度,注意先后顺序,站点名称、经度、纬度,每一行一个点位
(2) 打开代码编译器,新建类模块,将可实现的代码复制到类模块中,代码运行过程中会在桌面生成一个points.kml文件
(3) 运行代码即可实现kml文件的创建,同时可以通过表格和谷歌地球之间来回操作,方便在会审的时候使用
可实现代码
Sub CreateKMLFile()
Dim fs As Object
Dim f As Object
Dim rng As Range
Dim cell As Range
Dim filename As String
Dim kml As String
' 获取选定区域
Set rng = Selection
' 创建KML文件内容
kml = "<?xml version=""1.0"" encoding=""UTF-8""?>" & vbCrLf & _
"<kml xmlns=""http://www.opengis.net/kml/2.2"">" & vbCrLf & _
"<Document>" & vbCrLf
For Each cell In rng.Rows
kml = kml & "<Placemark>" & vbCrLf & _
"<name>" & cell.Cells(1, 1).Value & "</name>" & vbCrLf & _
"<Point>" & vbCrLf & _
"<coordinates>" & cell.Cells(1, 2).Value & "," & _
cell.Cells(1, 3).Value & ",0</coordinates>" & vbCrLf & _
"</Point>" & vbCrLf & _
"</Placemark>" & vbCrLf
Next cell
kml = kml & "</Document>" & vbCrLf & "</kml>"
' 保存KML文件
Set fs = CreateObject("Scripting.FileSystemObject")
filename = Environ("USERPROFILE") & "\Desktop\points.kml"
Set f = fs.CreateTextFile(filename, True, True) ' 修改为UTF-8编码
f.Write kml
f.Close
' 打开KML文件
Shell "explorer.exe """ & filename & """", vbNormalFocus
End Sub