Hi all and devs,
Using an Excel Scope, with a filepath in a variable, when the file is in use, the Excel Write Range activity is automatically saving the file locally to “C:\Users\<username>\Documents”.
Or am I going crazy?
I’m wondering if this is something anyone else is noticing.
Studio and OS version used:
Excel Activity version:
I will probably end up using Workbook Read Range to check if file is in use before entering Excel Scope so I can throw an error as desired.
Assuming I’m not crazy and this is indeed a problem here are my solution Ideas:
- I think the Excel Write Range should either throw an error when it is in use or (preferrably) change the filename to include a number like “directory\filename (2).xlsx” or “directory\filename (3).xlsx”