https://community.blueprism.com/t5/Product-Forum/Attaching-excel-instance-by-excel-vbo-with-macro/m-p/87923#M38564 Hi Pooja,<BR /><BR />Trying to understand what's going on: So your XL is already opened and your process has attached to it (by creating an instance) and when you access it the process creates a new instance?<BR /><BR />The usual way to use an existing XL in a process is:<BR /> <UL> <LI>create an instance (you'll get a handle back)</LI> <LI>open the XL with the handle and path</LI> <LI>work with the XL (get data, write data)</LI> <LI>save (or save as) the XL&nbsp;</LI> <LI>close the XL</LI> </UL> If you don't start by creating an instance, you do not have a handle and the process cannot open the XL.<BR /><BR />------------------------------<BR />Happy coding!<BR />---------------<BR />Paul<BR />Sweden<BR />------------------------------<BR /> Wed, 02 Nov 2022 07:16:00 GMT PvD_SE 2022-11-02T07:16:00Z https://community.blueprism.com/t5/Product-Forum/Attaching-excel-instance-by-excel-vbo-with-macro/m-p/87922#M38563 I have an issue where i am trying to run macro on the workbook opened by excel but it instead is creating a new excel instance to run the macro on that.<BR /><BR />------------------------------<BR />Pooja Verma<BR />------------------------------<BR /> Wed, 02 Nov 2022 04:42:00 GMT https://community.blueprism.com/t5/Product-Forum/Attaching-excel-instance-by-excel-vbo-with-macro/m-p/87922#M38563 PoojaVerma 2022-11-02T04:42:00Z https://community.blueprism.com/t5/Product-Forum/Attaching-excel-instance-by-excel-vbo-with-macro/m-p/87923#M38564 Hi Pooja,<BR /><BR />Trying to understand what's going on: So your XL is already opened and your process has attached to it (by creating an instance) and when you access it the process creates a new instance?<BR /><BR />The usual way to use an existing XL in a process is:<BR /> <UL> <LI>create an instance (you'll get a handle back)</LI> <LI>open the XL with the handle and path</LI> <LI>work with the XL (get data, write data)</LI> <LI>save (or save as) the XL&nbsp;</LI> <LI>close the XL</LI> </UL> If you don't start by creating an instance, you do not have a handle and the process cannot open the XL.<BR /><BR />------------------------------<BR />Happy coding!<BR />---------------<BR />Paul<BR />Sweden<BR />------------------------------<BR /> Wed, 02 Nov 2022 07:16:00 GMT https://community.blueprism.com/t5/Product-Forum/Attaching-excel-instance-by-excel-vbo-with-macro/m-p/87923#M38564 PvD_SE 2022-11-02T07:16:00Z