I have an “Excel Application Scope” Activity. Inside that I loop an array that provides keys to update a workbook. I have an “Use Excel File” activity that I have tried both settings for the “save changes” check box. I use filter activities to select the row I want to update. I am able to update the cells desired. I try a Save activity and it fails saying the workbook is not writable. This is similar behavior when Save Changes is checked.
Just before the excel scope activity:
I tried a Kill activity with word “excel”.
I tried a Invoke Code activity with “File.SetAttributes(filePath, FileAttributes.Normal)”
I tried setting workbook visible to false in scope
only a Save As activity works. But I need to update the original
For Each: File C:\Users\filename.xlsm is read-only and can not be modified. If you need to update it, please make sure the file is writable.
Can anyone help?