Hi guys,

I have been struggling on this issue for way too long now, and it's driving me nuts.

Point of my little code is that a masterfile (containing the code) will open 4 excel daugtherfiles from a sharepoint and replace a sheet in these 4 files with sheets coming from the masterfile. Once the replacing has been done, the 4 files will be closed and saved again. And it is this final step where it all goes wrong, when the daughterfiles are opened, they are opened as "ReadOnly" (even though I specify readonly:=false), making it impossible to save them back to the Sharepoint without manual intervention. Any idea why the readonly:=false does not work?

NB: I tried adding the LockServerFile command to the 4 daughter files on workbooks.open, but this doesn't work either.

Any help would be greatly appreciated!

Please Login or Register  to view this content.