>The file name or path does not exist
>The file is being used by another program.
>The workbook you are trying to save has the same name as a currently open workbook.
None of these are true in my case.
It is happening with all my colleagues desktop in Windows 11 Enterprise 10.0.22621 and Excel 365 version 2312.
We have tried changing the highlighted part of the VB code to a UNC path instead of a drive path but that hasn't worked.
Workbooks.Open Filename:="\Myserver01\pwr\Money\Cockpit\PositionCockpit.xlsm", Local:=True
He does have read/write access to the location in question, on the error message box if he clicks on End, after 3 attempts it works.
Question is why does this keep happening?

