close
【EXCEL】- VBA - EXCEL讀取文字檔(txt)
⬛ 問題:EXCEL - VBA - EXCEL如何讀取文字檔(txt)?
⬛ 回答:
以下將EXCEL VBA的範例先記錄下來,日後可以參考。
Sub READ_TXT() Dim ReadPath As String ReadPath = ActiveWorkbook.Path & "\" & "list.txt" Open ReadPath For Input As #1 Range("A1").Select Do Until EOF(1) '從#1檔案讀取一行 Line Input #1, 轉存區 ActiveCell.Value = 轉存區 ActiveCell.Offset(1, 0).Select Loop Close #1 End Sub
延伸閱讀
全站熱搜
留言列表