altough i have an office for mac 2019 installed Mac, i am not familiar with mac vba.

perhaps below site may help:
https://macexcel.com/examples/filesa...efolderexists/