https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75157#M27762 Save the object at a different name MS Excel VBO Extended Thu, 21 Dec 2017 14:07:00 GMT Christer_Tellefsen 2017-12-21T14:07:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75151#M27756 Hello, I have added logic to MS Excel VBO to color a cell when the cell range input range is passed.  I just believe it is not a good practice because we will have to provide the MS Excel VBO to be imported in the production server if there is any new update released by Blueprism we will have to keep integrating it.. Is there any other way to handle this ? Tue, 19 Dec 2017 12:08:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75151#M27756 RajathGopal 2017-12-19T12:08:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75152#M27757 Yes, make a copy of the VBO and put your amendments in the duplicate. Leave the original intact so you can import an newer version without overwriting your bespoke code. You can apply the same principle to all the utility objects. Tue, 19 Dec 2017 15:12:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75152#M27757 John__Carter 2017-12-19T15:12:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75153#M27758 Best practice is to never amend the standard package Blue Prism VBOs. If you want to create a new action you should add it to a seperate object rather than amending a Blue Prism VBO.  To do this with Excel I have previously created a copy of the standard VBO with my new extended name and deleted all the actions except the ones related to lauch and attach.  Then I added my new actions into it.  When interfacing with Excel I might then have two objects connected to it. Tue, 19 Dec 2017 17:05:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75153#M27758 Denis__Dennehy 2017-12-19T17:05:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75154#M27759 I also tried saving the MS Excel VBO as a new Object and tried modifying it but i was unable to execute the stage that i need as it was failing in Check Handle stage. So if any of you guys have added an extra stage could you please help me out with it as to how you went through it Tue, 19 Dec 2017 22:33:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75154#M27759 RajathGopal 2017-12-19T22:33:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75155#M27760 I get an error ""The given key was not present in the dictionary"" when i create a new extended object and use the same to perform the action Wed, 20 Dec 2017 12:19:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75155#M27760 RajathGopal 2017-12-20T12:19:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75156#M27761 You can use a macro to handle excel work, just call the macro from BluePrism. Wed, 20 Dec 2017 18:13:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75156#M27761 IshanMahajan 2017-12-20T18:13:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75157#M27762 Save the object at a different name MS Excel VBO Extended Thu, 21 Dec 2017 14:07:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75157#M27762 Christer_Tellefsen 2017-12-21T14:07:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75158#M27763 You can try cloning MS Excel VBO , rename it as required, make necessary changes for color formatting and package it with your Blue Prism release. Fri, 22 Dec 2017 15:01:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75158#M27763 RekhaR 2017-12-22T15:01:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75159#M27764 You can use code stage for formatting the excel sheet any way you want. All you need is Interop DLL. Code stage will allow you to do formatting in few lines. Tue, 26 Dec 2017 22:35:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75159#M27764 JivankumarKedar 2017-12-26T22:35:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75160#M27765 Thanks for your replies.  I actually did try saving it as a new one and then amending my actions to a new one. When i do this it always fails and i get an error ""The given key was not present in the dictionary"".  I am not sure why i am receiving this error i tired copying the MS Excel VBO from the previously existing one and added the new actions, also tried importing a new one and then added the new actions but still no go it just throws an error as mentioned above.  Any idea where i am going wrong  Wed, 03 Jan 2018 12:32:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75160#M27765 RajathGopal 2018-01-03T12:32:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75161#M27766 The thing is that it works when amended in the original MS Excel VBO but not in the extended one even though they both are exactly the same  Wed, 03 Jan 2018 12:33:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75161#M27766 RajathGopal 2018-01-03T12:33:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75162#M27767 any comments on this ?? Wed, 03 Jan 2018 18:04:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75162#M27767 RajathGopal 2018-01-03T18:04:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75163#M27768 The fact it works in one VBO but not another one tells me they are not exactly the same.  Do a Save As on the original one, remove standard actions appart from the start/attach/exit actions - and bingo, you have a new extended vbo with your working action in... Thu, 04 Jan 2018 17:00:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75163#M27768 Denis__Dennehy 2018-01-04T17:00:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75164#M27769 Hey Denis I did try the save as but still no go...Removed all the actions except for the ones that i need i stepped in each stage to determine where exactly it is failing it reaches to check handle stage in checkinstancehandle action and it fails but what makes it strange is i am not sure how it works when modified in the original one.  Please find the attached error. Fri, 05 Jan 2018 09:12:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75164#M27769 RajathGopal 2018-01-05T09:12:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75165#M27770 Hi Rajath, Do you use both VBOs in the same time? I've got exactly the same issue, when I opened xls using orignal VBO and then tried to connect with my custom VBO. I ended up with using only my custom VBO. Regards, Tomek A. Mon, 08 Jan 2018 19:48:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75165#M27770 TomaszAdamski 2018-01-08T19:48:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75166#M27771 Hey Tomek,  Yep i actually do use both the VBO's. I am just using the custom VBO for coloring the excel cell rest other actions are being called from the main Excel VBO. Tue, 09 Jan 2018 21:20:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75166#M27771 RajathGopal 2018-01-09T21:20:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75167#M27772 seems this issue is coming due to duplicate pages which has duplicate codes as well. try deleting others pages from newly created Excel VBO and keep only that page which you are going to use. Also keep in mind others codes should not be deleted else this may create also a problem. Hope it should work. Tue, 09 Jan 2018 23:08:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75167#M27772 Amit_KumarSingh 2018-01-09T23:08:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75168#M27773 Hey Amit, I do not believe it is because of duplicate pages and codes as i have tried removing them at the beginning. I believe that handle created using the original MS Excel VBO and then passing that as an input to the custom one is creating an error. i will have to try launching the excel as well from the custom VBO and give it a shot and check if that works Wed, 10 Jan 2018 12:29:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75168#M27773 RajathGopal 2018-01-10T12:29:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75169#M27774 This issue has been fixed thanks for you support guys. It was because handle created using the original MS Excel VBO and then passing that as an input to the custom one was generating that error Mon, 15 Jan 2018 11:35:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75169#M27774 RajathGopal 2018-01-15T11:35:00Z https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75170#M27775 How to use MS Excel VBO-Format Cell? Tue, 16 Jan 2018 23:39:00 GMT https://community.blueprism.com/t5/Product-Forum/MS-Excel-VBO/m-p/75170#M27775 Anonymous 2018-01-16T23:39:00Z