I am opening excel using Excel Application Scope and assigning some variable in Output and while using Close Workbook activity I am giving the same variable name in Target property. But still I am getting an error. Also I am using the close workbook activity within the scope of Excel Application Scope activity.
I understand this issue has already been sort of mentioned/addressed however I am wondering how to relate to this compiling error: "Value of type âUiPath.Core.Windowâ cannot be converted to âUiPath.Excel.WorkbookApplicationâ
the first type is the variable defined for the attached window when using Excel Application scope
I have used the same variable in the âClose workbook activityâ outside the scope, and thats when i get the compiling error.
sorry I used a start process activity to open the file not an excel application scope, my apologies for the mix up.
after the start process activity then i used an attach window to house all the activities which is ok.
it is the output variable of the attached window
that I am trying to use as target for the close workbook activity.
I donât get it why you wanna do it with attach window and then coming back to workbook activity there is a mismatch of variable.
However if you want to use attach window then use âClose windowâ activity which do accept âUiPath.Core.Windowâ as windows variable .
Close workbook works if your opening file in Excel Application scope activity