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?
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
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
Its not working still get “excel is opened by other”
Can you try with excel application scope?