I need to write formula in excel get the value obtained from formula

I need to write formula in excel get the value obtained from formula .I have used write cell activity while using that I have often got this error"write cell:the excel is opened by another user" .I have given delay and tried still facing the issue .I have not use write cell in excel scope activity.Canyou help me to write cell in vb code??

Is that excel file in common shared folder?

No.its not in common folder

So, you have used write cell workbook activities, right?

Hi
Before writing to excel use KILL PROCESS activity and pass the ProcessName as “EXCEL” and then try writing

Once after writing it you would like to read the value from that same cell use READ CELL activity

Cheers @sruthesanju

Yes I have used write cell work book

Can you check the flow once whether you open that excel file through excel application?

If yes means, then please use close workbook after that excel application scope

I have not used any excel scope activity

Did you try @Palaniyappan solution?

I think it will work

1 Like

Its not working still get “excel is opened by other”

Can you try with excel application scope?