Robot Error help needed

Any one know what is the problem with my robot?
T2_Finalise_1.1.1.xaml (37.8 KB)

Hi @CHAN_Hiu_Fung_Victor_Stud

Don’t use Workbook activities within the excel activities. Keep the workbook activities outside excel activities or instead of workbook activities use Excel activities itself.

Regards,

Hi @CHAN_Hiu_Fung_Victor_Stud

As mentioned in the previous question raised by you, please place the Workbook activities outside Use Excel File eice Workbook activities will throw an error if the excel is in open and Excel activities opens the excel in Background phase. So, please drag the Workbook activities outside Use Excel File and your flow is good to go.

Hope you understand!!
Regards

Hi,

FYI, another approach:

If there is some reason to use Workbook activities inside useExcelFile, the following may help you.

First, clear file path at Workbook path property.
Then input the following expression at Workbook property.

new UiPath.Excel.WorkbookApplication(Excel.FilePath)

Apply the above to all the workbook activities inside UseExcelFile.

Regards,