|
没有附件无法判断
参考:
- Sub Opiona()
- Dim f
- 'On Error Resume Next
- Application.ScreenUpdating = False '关闭屏幕刷新
- Application.DisplayAlerts = False '关闭提示
- t = Timer
- s = "\*.txt"
- Set sh1 = Sheets("读取后")
- sh1.Cells.ClearContents
- n = 1
- f = Dir(ThisWorkbook.Path & s) '生成查找EXCEL的目录
- Do While f > " " '在目录中循环
- sh1.Cells(n, 1) = ReadFromFileADO(ThisWorkbook.Path & "" & f, "UTF-8")
- n = n + 1
- f = Dir
- Loop
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- MsgBox "用时:" & Format(Timer - t, "#0.0000") & " 秒", , "北极狐提示!!"
- End Sub
- ’,需要添加对ADO 对象库的引用
- ‘ADO方式读取
- '功能:读取text文件(ADO方式,需要添加对ADO 对象库的引用)
- '输入:输入文件地址、字符集
- '输出:无
- Function ReadFromFileADO(filePath As String, CharSet As String) As String
- Dim strRtn As String
- Set stm = CreateObject("ADODB.Stream")
- stm.Type = 2 '以本模式读取
- stm.Mode = 3
- stm.CharSet = CharSet
- stm.Open
- stm.LoadFromFile filePath
- strRtn = stm.ReadText
- stm.Close
- Set stm = Nothing
- ReadFromFileADO = strRtn
- End Function
复制代码 |
|