Opening files on network drive

[JKwan]

I am using VBA to open files on a network drive, works good. However, when a file is opened by someone else, the program stopped and ask if you want to be "notify, read only", can I tell VBA to open the file as read only if the file is locked?

Thanks.

[JKwan]

I think I got it solved by adding ReadOnly:=True to my Open method.