dir function is not working on colleagues PC

Hi,

I am trying to import a csv sheet on a daily basis. The sheet is named after the exact timestamp when it was created. The seconds are changing everyday thats why I need the "Dir" function to complete its name. On my PC (using Excel 2019) the code works fine but when my collegue, who is using Excel 2019, too, is trying to run the code, it always crashes when looking up the filename.

Is there any library he needs to import to VBA so he can run the function? Are there any other mistakes we are making?

Thanks in advance!

All the basic libraries are loaded by default, certainly if you're using the VBA DIR command. Any error message?

As a check, you can use the Tools/References menu in the VBA editor to check for anything listed as 'MISSING'.

And define 'crash' - an error message?, Excel closes? Blue screen of Death ...???

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

Some of the staff in our office have a different drive share letter (e.g. "T") ... have you gone to your peers computer and checked that he/she has the exact path and file ?

Thats a very good point since we have some weird letters in the german language like "ü" which is included in the file path and could be spelled like "ue". I will look into it tomorrow since he has already left the office.
Thanks!