Gibt es einen VBA Code, der die Besucher meiner Exceldateien mit Datum speichert?
Die Dateien liegen auf einem Firmenserver, falls diese Information wichtig sein sollte.
Vielen Dank und viele Grüße
Thomas
Option Explicit
Private Sub Workbook_Open()
Dim F As Integer
Dim sFilename As String
sFilename = IIf(Right$(ThisWorkbook.Path, 1) = "\", ThisWorkbook.Path, ThisWorkbook.Path & "\")
sFilename = sFilename & "Userzugriff.txt"
F = FreeFile
Open sFilename For Append As #F
Print #F, CStr(Environ$("Username") & " " & Format(Now, "hh:mm:ss dd.mm.yyyy"))
Close #F
End Sub
Gruß Tino
Private Sub Workbook_Open()
Dim F As Integer
Dim sFilename As String
sFilename = IIf(Right$(ThisWorkbook.Path, 1) = "\", ThisWorkbook.Path, ThisWorkbook.Path & "\")
sFilename = sFilename & "Userzugriff.txt"
F = FreeFile
Open sFilename For Append As #F
Print #F, CStr(Environ$("Username") & " " & _
Format(Now, "hh:mm:ss dd.mm.yyyy ") & _
ThisWorkbook.Name)
Close #F
End Sub
Gruß Tino