problem with open a .xlxs file, someone else is using it

Question

i have a problem when i try to open a file .xlxs in a public disk P: with VBA Code. The file show me a message "please try again later - ERROR 1004". Many user use this file and this error is frequently usual. There is a solution for this ?

I think in copy the file and paste to my desktop but that is a lot of wasted time because is a large file.

Workbooks.Open filename:=nameofmyfile, Notify:=True, ReadOnly:=True

Answer 1

Try below and let us know if it works.

Use shared workbooks with different versions of Excel

https://learn.microsoft.com/en-us/office/troubleshoot/excel/use-shared-workbook