With the latest update of the UiPath studio, there are concerns around the Excel Application Scope as it throws out validation errors. Many are complaining about this error “Excel Workbook Application is not defined”, and I have personally come across this in my automation solutions.
You could easily locate this error by simply clicking on the Validate button on the top ribbon. If you have excel application scope, most probably you’ll see this error. It doesn’t show up unless you do this validation. And even though this error persists, you will not see a validation icon on the top of the Excel Application Scope.
As you see here, the Excel Application Scope is pretty fine.
So this error is caused by this property of the Excel Application Scope
The way to resolve this is by creating a WorkBook Application type variable and assigning it to this output argument. You can simply click there, and press CTRL + K and then type the variable name. This will create the workbook application type variable and assign it to the output argument of this activity.
Once done, click on the Validate All and see the error gone
For all the projects that run on latest versions, having this will be really required. In might work fine, but this validation error will stop you from validating the solution and even from publishing to the orchestrator. So if you have the Excel Application Scope used, make sure to apply this change and it will be fine after that
Thank you and Happy Automating!!!