cancel
Showing results for 
Search instead for 
Did you mean: 

iRPA: Fail to switch excel file

314

I would like to write the data on 3 opened excel files in difference sheet name but It show me the error about fail to activate sheet on the 1st or 2nd excel.

Thank you.

Atipat S.

Accepted Solutions (0)

Answers (2)

Answers (2)

Is there any other solution besides open and close excel one by one?

Thank you.

Aitpat

peterengel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I think you have missed to activate the workbook before activating the sheet.

Br,

Peter

0 Kudos

Hi Peter,

I already activated the workbook. My workflow's steps

1. Get workbook list--> It gave me the name of all the opened excel.
2. Activate workbook --> No any error.
3. Get sheet list --> It gave me the correct sheets in activated workbook in step 2.
4. Activate sheet --> It gave me an error about out of range.

It possible to activate sheet on the latest opened file only.

Thank you.

Atipat

peterengel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

do you work with Desktop Studio or Cloud Studio?

Br,

Peter

0 Kudos

Hi,

Desktop Studio 2.0.5.69.

Atipat