Textdateien einlesen

Beiträge zum Forumthread

Beiträge zu diesem Forumthread

Betreff

Datum

Anwender

Sub einlesen() Dim fso As Object Dim fo As Object Dim f As Object Dim lng As Long Dim text1 As String Set fso = CreateObject("Scripting.FileSystemObject") Set fo = fso.GetFolder("G:\ALLG_A14\HOST\BUKUZ\BUKUZ01032004\Ooe\") For Each f In fo.Files Open f.Path For Input As #1 Do While Not EOF(1) Line Input #1, text1 If Mid(text1, 21, 2) = "01" Then lng = lng + 1 Cells(lng, 1) = text1 End If Loop Close #1 Next 'f End Sub

Guten Morgen Ingolf!
Danke für Deine Hilfe. Es passt alles. Ich habe es noch mit einer Ordnerauswahl ergänzt.
Option Explicit
Private Type BrowseInfo
hwndOwner As Long
pIDLRoot As Long
pszDisplayName As Long
lpszTitle As Long
ulFlags As Long
lpfnCallback As Long
lParam As Long
iImage As Long
End Type
Private Const BIF_RETURNONLYFSDIRS = 1
Private Const MAX_PATH = 1000
Private Declare Sub CoTaskMemFree Lib "ole32.dll" (ByVal hMem As Long)
Private Declare Function lstrcat Lib "kernel32" Alias "lstrcatA" (ByVal lpString1 As String, ByVal lpString2 As String) As Long
Private Declare Function SHBrowseForFolder Lib "shell32" (lpbi As BrowseInfo) As Long
Private Declare Function SHGetPathFromIDList Lib "shell32" (ByVal pidList As Long, ByVal lpBuffer As String) As Long
Sub einlesen()
Dim fso As Object
Dim fo As Object
Dim f As Object
Dim lng As Long
Dim text1 As String
Dim pf$
Workbooks.Add
pf = BrowseForFolder(0, "Pfad für die Textdateien wählen ..")
If pf = vbNullString Then Exit Sub
Set fso = CreateObject("Scripting.FileSystemObject")
Set fo = fso.GetFolder(pf)
For Each f In fo.Files
Open f.Path For Input As #1
Do While Not EOF(1)
Line Input #1, text1
If Mid(text1, 21, 2) = "01" Then
lng = lng + 1
Cells(lng, 1) = text1
End If
Loop
Close #1
Next 'f
End Sub


Private Function BrowseForFolder(hwndOwner As Long, sPrompt As String) As String
Dim iNull As Integer
Dim lpIDList As Long
Dim lResult As Long
Dim sPath As String
Dim udtBI As BrowseInfo
With udtBI
.hwndOwner = hwndOwner
.lpszTitle = lstrcat(sPrompt, "")
.ulFlags = BIF_RETURNONLYFSDIRS
End With
lpIDList = SHBrowseForFolder(udtBI)
If lpIDList Then
sPath = String$(MAX_PATH, 0)
lResult = SHGetPathFromIDList(lpIDList, sPath)
Call CoTaskMemFree(lpIDList)
iNull = InStr(sPath, vbNullChar)
If iNull Then sPath = Left$(sPath, iNull - 1)
End If
BrowseForFolder = sPath
End Function

Schönen Tag noch
Josef

Beliebteste Forumthreads (12 Monate)

5
Beiträge zum Forumthread

Beiträge zu diesem Forumthread

302 Forumthreads zu ähnlichen Themen

Beliebteste Forumthreads (12 Monate)

Beliebteste Forumthreads (12 Monate)

Textdateien einlesen

5 Beiträge zum Forumthread Beiträge zu diesem Forumthread

302 Forumthreads zu ähnlichen Themen

VBA Beispiele zu verwandten Themen

Beliebteste Forumthreads (12 Monate)

Beliebteste Forumthreads (12 Monate)

5
Beiträge zum Forumthread

Beiträge zu diesem Forumthread