AW: Datei-Eigenschaften auslesen
03.08.2016 15:33:43
Michael
Hallo!
Gelle ;-)... Hier mit Hinweis:
Sub ShowLastMod()
'Auf dem Blatt Upload-Info, in A1:C3 stehen Überschriften,
'd.h. Pfad- und Dateieinträge ab A2.
Const STR_BLATT As String = "Upload-Info"
Dim Wb As Workbook
Dim Ws As Worksheet
Dim r As Range
Dim f As Range
Dim sPfad As String
Dim sDname As String
Dim oFSO As Object
Dim oFile As Object
Set Wb = ThisWorkbook
Set Ws = Wb.Worksheets(STR_BLATT)
Set oFSO = CreateObject("Scripting.FileSystemObject")
With Ws
Set r = .Range("A2:A" & .Cells(.Rows.Count, 1).End(xlUp).Row)
For Each f In r
If Not f.Value = vbNullString Then
sPfad = f.Text
If Right(sPfad, 1) "\" Then sPfad = sPfad & "\"
sDname = f.Offset(, 1).Text
If oFSO.FileExists(sPfad & sDname) = True Then
Set oFile = oFSO.getfile(sPfad & sDname)
f.Offset(, 2).Value = oFile.DateLastModified
Else: f.Offset(, 2).Value = "Datei nicht gefunden!"
End If
End If
Next f
End With
End Sub
Passt?
LG
Michael