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

Help Activities
1

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??

2

Is that excel file in common shared folder?

3

No.its not in common folder

4

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

5

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

6

Yes I have used write cell work book

7

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

8

I have not used any excel scope activity

9

Did you try @Palaniyappan solution?

I think it will work

1 Like
10

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

11

Can you try with excel application scope?