Open myFile For Binary Access Read Lock Read As #1įileInUse = IIf(Err.Number > 0, True, False) Then it returns True/False if the file is in use or not: On Error Resume Next The code below basically opens/closes 'myFile' in the background, and checks if any error was raised while trying to open it. One approach I tried was to check if the file is currently in use, before opening it: I've been unsuccessfully trying to find a code that could bypass this message, so the macro could handle it programmatically. Since the file to be updated must be open with read/write permissions the macro will not be able to perform the upload. The issue is that when multiple users start an upload at the exact same time (which is not very likely, but possible), the upload procedure runs only for one user, and the rest are prompted with the following message: I'm working on a vba-excel project that lets multiple users upload data programmatically to a specific ( EDIT: password protected) file located in our company's SharePoint.
0 kommentar(er)
