Hello,
I have a macro which opens another workbook to transfer data. This task is completed by several other workbooks as well. Even though this buffer workbook is only opened for a few seconds, there may be times when it is already opened by another sheet at the same time as another attempts to access it. Is there a way I could get the macro to loop around until it is sucessful in transfering the information and saving the buffer. All the files are on sharepoint.

Thanks

Colin