|
Cells(c, 4) = ReadUTF(f) 出现乱码
Sub 按钮1_Click()
Set fso = CreateObject("scripting.filesystemobject")
Application.ScreenUpdating = False
r = 2
For Each f In fso.getfolder(ThisWorkbook.Path).Files
If InStr(f.Name, ".txt") > 0 Then
For c = 2 To 1000
If Cells(c, 1) = Split(f.Name, ".txt")(0) Then Cells(c, 4) = ReadUTF(f)
Next
r = r + 1
End If
Next f
Application.ScreenUpdating = True
End Sub
Function ReadUTF(ByVal FileName As String) As String
With CreateObject("ADODB.Stream")
.Type = 2
.Mode = 3
.Open
.LoadFromFile FileName
.Charset = "UTF-8"
.Position = 2
ReadUTF = .ReadText
.Close
End With
End Function
求助附件.rar
(12.32 KB, 下载次数: 7)
|
|