We are encountering an issue in one of our processes where we save an Excel file with a specific name to a given path. When running the process, the text in the filename is sometimes altered randomly. For example, it might change the case of some characters or add strange symbols. The behavior is inconsistent; occasionally, it works correctly, while other times, different issues appear with the text.
Has anyone experienced similar behavior, or is there a recommended approach to prevent this?
No, the text isn’t coming from an Excel cell. It’s a literal string, placed between quotation marks, that is being typed directly using the ‘Type Into’ activity.
I’ve had similar issues with the Save As dialog and Type Into, so I use the Set Text activity. Another alternative is to use Set to Clipboard, then Click the box, then Keyboard Shortcuts (CTRL+V).