Forum Discussion
Excel disable Read-Only from SharePoint with VBA
Hello Group, We have a lot of Excel files that are saved with "read-Only recommended". I would like to open files with VBA and also capture the click on "Edit Anyway" in code. I ...
NikolinoDE
Thank you Nikolino, but the problem doesn't exist when I open the file (manually) from SharePoint, but when I open it with VBA.Thanks again Nikolino,
In the code which Vit has found, is the same statement I have used:
His:Set wb = xlApp.Workbooks.Open(xlFile, , False)Mine:
Set wb = exApp.Workbooks.Open(Filename:=sfilename, ReadOnly:=False)But alas, it still results in a Read-Only opened file.
ReadOnly:=False is simply ignored.
