Share via

Microsoft Excel cannot access the file: Excel VB FileOpen

Anonymous
2024-03-21T11:23:51+00:00

>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?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

  2. Anonymous
    2024-03-21T13:35:43+00:00

    Could you upload your screenshot agian? Then we may try reproducing your issue.

    You may raise a new thread in Stack Overflow which is special channel to handle VBA questions.

    Stack Overflow

    Was this answer helpful?

    0 comments No comments