Hi all,
I’m having troubles opening an Excelfile (stored on SharePoint) via de Excelscope activity.
The files only open as read-only. As a result of this the write range activity becomes useless.
Is there any workaround?
Kind regards
Hi all,
I’m having troubles opening an Excelfile (stored on SharePoint) via de Excelscope activity.
The files only open as read-only. As a result of this the write range activity becomes useless.
Is there any workaround?
Kind regards
How about downloading the file then use the saved file in Excel Application Scope?
The workaround I used is:
If InStr(1, Application.Caption, “Read-Only”) > 1 Then
ActiveWorkbook.LockServerFile
Else
End If
End Sub