Hello,
I have a spreadsheet that is updated with a macro finding the latest download in an appropriate folder. It looks as follows:
MyPath = "C:\User1\Downloads"
MyFile = Dir(MyPath & "*.xls", vbNormal)
......
Everything is working fine. Unfortunately, recently all the users have been...