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

Honestly, Excel is not a good front end program. If many users are expected to simultaneously use and update a file, any kind of database solution is going to be better suited (even if it's as simple as using MS Access) — tigeravatar
– tigeravatar, Commented Oct 12, 2023 at 14:00

vbakim · Accepted Answer · 2023-10-12 15:30:46Z

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

answered Oct 12, 2023 at 15:30

vbakim

6211 gold badge3 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lautaro Tita Over a year ago

when somebody is using the file, the name of the file use this symbols "∼$". I modified my code and i search a the second old file and that symbols no disturb my code.

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related