|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub mydiag()
Application.FileDialog(msoFileDialogFilePicker).Show
End Sub
Sub Open方法()
Dim d, ky, i, sr$, temp
Dim filter As String
Dim fileToOpen
filter = "Text Files(*.txt),*.txt "
fileToOpen = Application.GetOpenFilename(filefilter:=filter, FilterIndex:=2, Title:="请选择文件") '打开文件
Set d = CreateObject("scripting.dictionary") '引用字典
With Sheets("sheet2")
.UsedRange.ClearContents '清除原有的数据
i = 1
Open fileToOpen For Input As #1 '使用open语句输入
Do While Not EOF(1) '运行到文件的结尾结束
Line Input #1, sr '按行读取数据
If Len(sr) > 0 Then
ky = Split(sr, "_", 2)(0)
d(ky) = Split(sr, "_")(1) & "," & Split(sr, "_")(2) '以,连接服务器名称和人名
'Debug.Print ky & " : " & d(ky)
i = i + 1
End If
Loop
Close #1 '关闭文本文件
.Range("a1").Resize(d.Count, 1) = Application.Transpose(d.keys) '将IP写入单元格
i = 1
For Each ky In d.keys '将服务器名称及人名写入表格
Cells(i, "B").Resize(1, 2) = Split(d(ky), ",")
i = i + 1
Next
End With
Set d = Nothing
End Sub
|
|