In the course “Build Automation using Excel Modern Activities”, the instructor uses “In the Excel file, we’ll enter the “Output\ Month Report” file path and reference it as MonthReport.” multiple times, but when I try to do the same, I receive “Error: System.Exception: “MonthReport” is not a valid variable name! Found an item with the same variable name.” and it will not let me enter the value. I don’t see this as a variable under Data Manager, just a reference.
When I download the example project, I don’t get any errors as a result of being built this way, and I can freely edit the references to be the same.
The error message that shows up after I try to exit the reference as box:
You can find the course and files over here: UiPath Academy
Edit: Just tried to change the reference in the sourcefile to “test” and then changed it back and got the same error. Probably it has something to do with different versions of UiPath Studio when the projects was created.
I encountered a similar issue with the new version 2.23.3 preview. However, after decreasing the version to UiPath.Excel.Activities=2.16.1, it started working again.
Hi Alan Makranczy, I’ve determined that the issue lies with the reference name used to refer to the workbook in the folder.
To resolve this, we need to create a unique reference name for the workbook.
As demonstrated in the academy, using the same reference name worked in older versions of Excel (e.g., 2022), but it seems to be causing an error in our newer version.
Therefore, the solution is to provide a unique reference name in the “Use File” activity.
Please let me know if you’re unable to fix the issue.