|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 xyxcc177 于 2019-6-24 10:50 编辑
- Sub test()
- Dim f As String
- f = ThisWorkbook.Path & "\test.csv"
- Dim txt As String
- txt = UTF8ToGB2312(f)
- MsgBox txt
- End Sub
- Public Function UTF8ToGB2312(ByVal filename As String) As String
- Dim chs() As Byte, i As Integer, k As Integer
- Dim adoStream As Object
- Open filename For Binary As #1
- For i = 0 To LOF(1) - 1
- k = k + 1
- ReDim Preserve chs(1 To k) As Byte
- Get #1, , chs(k)
- Next i
- Close #1
- Set adoStream = CreateObject("ADODB.Stream")
- adoStream.Charset = "utf-8"
- adoStream.Type = 1
- adoStream.Open
- adoStream.Write chs
- adoStream.Position = 0
- adoStream.Type = 2
- UTF8ToGB2312= adoStream.ReadText()
- adoStream.Close
- End Function
复制代码
|
|