AW: Log-File erstellen
20.10.2016 10:23:21
UweD
Hallo
meinst du das so?
In ein Modul
Sub Log_erstellen()
Dim TB, Pfad As String, Datei As String
Set TB = Sheets("Tabelle1")
Pfad = "C:\Temp\" & "Log-File\"
If Dir(Pfad, vbDirectory) = "" Then MkDir Pfad
Datei = Pfad & Left(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".")) _
& "txt"
Close #1
If Dir(Datei) = "" Then
Open Datei For Output As 1
Else
Open Datei For Append As 1
End If
Print #1, Format(Now, "YYYY_MM_DD") & "/" & Format(Now, "hh:mm:ss") & _
"/IN/" & TB.Range("A1")
Close #1
End Sub
in DieseArbeitsmappe
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim TB, Pfad As String, Datei As String
Set TB = Sheets("Tabelle1")
Pfad = "C:\Temp\" & "Log-File\"
Datei = Pfad & Left(ThisWorkbook.Name, InStrRev(ThisWorkbook.Name, ".")) _
& "txt"
Close #1
If Dir(Datei) = "" Then
MsgBox "Datei: '" & Datei & "' existiert nicht"
Exit Sub
End If
Open Datei For Append As 1
Print #1, Format(Now, "YYYY_MM_DD") & "/" & Format(Now, "hh:mm:ss") _
& "/OUT/" & TB.Range("A1")
Close #1
End Sub