The error message is basicly that the name he is looking for cannot be found within the given path.
It just stops the macro; no blue screens, no excel closings.
The code is the following:
Sub whsopss()
'
' whsopss Makro
'
Dim path As String
Dim path_drei As String
Dim Datum As Long
Dim timestamp As String
'datumsabhängigen whsops Name in Variablen Name einlesen
Datum = Format(Date, "YYYYMMDD")
path = "T:\Reports\Rueckstand\"
timestamp = Dir(path & "whsopsstatus_" & Datum & "*.csv*")
path = path & timestamp
Bookmarks