A bit of a strange one. All im doing is trying to create an excel file (for a report) using excel application scope.
However, it an error occurs as it cant access the file…looking at the error it seems as if the file part of the string is being changed within Excel Application Scope…
(Pic 1: View of workflow - assigning “C:\Users\CO\Documents\RPA\Report Extraction\Jul 2019\Extraction Report.xlsx” to string)
(Pic 2: Message box with the correct value)
(Pic 3: The error - note how the file part of the string changes to some random value…)
Does anyone have any idea as to what is happening?
AutoSave and CreateNewFile are the only options set true in the properties of Excel Application Scope