I have an activity where I copy a template file, then copy a sheet from another excel file to the copied template file. Unfortunately, it gives moe this ‘Document not saved’ error. Anyone knows what casues the issue?
did you try first closing the workbook before use the copy sheet activity?
as the documnetation says
kindly refer below thread
you can try with BalaReva activities once
I’m pretty sure they use office 365.
so Just try out with Bala Reva activities
I’ll try. Thanks.
try closing the wb with the close workbook activity. Create a new variable in the ouput section of the properties, and in Workbook propertie create a new variable, then pass it to the close workbook activity, then use the copy sheet activity again
Sorry I don’t get it. Do you mean I need to:
- Input Existing WorkBook Var
2.Copy to Existing WorkBook Var
- Close Input Existing WorkBook Var
- Copy Sheets.
- Output Copied Exisitng WorkBookVar