AW: Dateien eines Verzeichnis zählen -Liste-
01.06.2005 16:20:17
EffHa
Hallo Anton,
ich würde das wie folgt lösen:
Option Explicit
Private Declare
Function FindFirstFile Lib "kernel32" Alias "FindFirstFileA" ( _
ByVal lpFileName As String, lpFindFileData As WIN32_FIND_DATA) As Long
Private Declare
Function FindNextFile Lib "kernel32" Alias "FindNextFileA" ( _
ByVal hFindFile As Long, _
lpFindFileData As WIN32_FIND_DATA) As Long
Private Declare
Function FindClose Lib "kernel32" (ByVal hFindFile As Long) As Long
Const MAX_PATH = 260
Private Type FILETIME
dwLowDateTime As Long
dwHighDateTime As Long
End Type
Private Type SYSTEMTIME
wYear As Integer
wMonth As Integer
wDayOfWeek As Integer
wDay As Integer
wHour As Integer
wMinute As Integer
wSecond As Integer
wMilliseconds As Integer
End Type
Private Type WIN32_FIND_DATA
dwFileAttributes As Long
ftCreationTime As FILETIME
ftLastAccessTime As FILETIME
ftLastWriteTime As FILETIME
nFileSizeHigh As Long
nFileSizeLow As Long
dwReserved0 As Long
dwReserved1 As Long
cFileName As String * MAX_PATH
cAlternate As String * 14
End Type
Sub Zählen()
hier eine schleife mit den vorgegebenen Zellen
End Sub
Sub SearchFiles(PathName$, Pattern$, FoundFileNames)
Dim hFind&, hFile&, nFile& 'SDir$,
Dim FD As WIN32_FIND_DATA
Dim Counter&
On Error Resume Next
Counter = 0
If Right(PathName, 1) <> "\" Then PathName = PathName & "\"
hFile = FindFirstFile(PathName & FileName, FD) ' Pathname ist ja konstant,
If hFile > 0 Then 'Filename aus Tabelle
Counter = Counter + 1
Do
nFile = FindNextFile(hFile, FD)
If nFile > 0 Then
Counter = Counter + 1
End If
Loop While nFile <> 0
End If
FindClose hFile
End Sub