Save Excel 2003 when being opened as Read Only at the same time
Posted on 2011-05-10
I have a specific request which needs to make use of the Excel as multiple user tool, even though it is not good at.
I have a Search file which will open another one File_X.xls as Read only via vb script
Code: (For i = 1 To .FoundFiles.Count
Set oBook = Workbooks.Open(.FoundFiles(i), ReadOnly:=True)
File_X.xls is opened from UserA and then from UserB.
UserA is allowed to make some changes and via vba I store some information into database and then I need to save also the File_X.xls. The code for saving is simple: (ActiveWorkbook.Save)
Because the UserB has it open, UserA wanted to save gets a message: (A file named 'File_X.xls' already exists in this location. Do you want to replace it?)
When UserA clicks Yes option, it seems it has saved it. When re-opening, even after UserB has closed it, the change on the File_X.xls is not present.
I hope to have made it as clear as possible. A soon solution (preferably in VB) is appresciated.
Thanks in advance!