How to use the instance of Excel in open instead of opening the same file

Help Activities
, ,
1

Hi,

May I know how to use the instance of an excel file that is in open while using excel application scope because excel application scope opens a new instance of the same file?

2

Hi @Natarajan_Manojkumar,

I am not sure if I am getting right your question right But You can open the excel application scope at the very beginning and perform all the activities inside it this will not open same excel twice. Also we have a workbook property,

image

what you can do when you first time interact with that excel create a workbook variable for it as well and then moving forward in the code every time you need it you can use the existing workbook variable to work on the same excel instance.

Thanks

1 Like
3

You can implement it within the same block
Or
Assign the returned WorkBook from output to a variable and use it later again for the next EAS as ExistingWorkBook
grafik

1 Like
4

Thanks. Use existing workbook helps.

5

If it worked for you please mark it a solution so that the thread can be closed and others can refer it.

Thanks

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.