I'm using MS Access to open an Excel file and read information from it using the 'Microsoft Excel 8.0 Object Library'.
The file being opened is most likely located on an network drive. When another user on another machine has it open exclusively my excel object doesn't know that someone else has it open. When I update the comments and attempt to save the workbook, processing pauses until the other user closes the workbook, at which point my program continues and saves (overriding the changes of the other user).
Can someone help me determine whether or not another user has the file open exclusively?
The file being opened is most likely located on an network drive. When another user on another machine has it open exclusively my excel object doesn't know that someone else has it open. When I update the comments and attempt to save the workbook, processing pauses until the other user closes the workbook, at which point my program continues and saves (overriding the changes of the other user).
Can someone help me determine whether or not another user has the file open exclusively?
