PDA

View Full Version : [SOLVED] Opening files on network drive



JKwan
08-16-2013, 06:25 AM
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
08-16-2013, 08:58 AM
I think I got it solved by adding ReadOnly:=True to my Open method.