https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66779#M19384 Hi all, I am trying to open a workbook using the Excel VBO "Open Workbook" stage but there is a popup that appears saying "The user has requested that this document be opened as read only." There are buttons to click "yes, no or cancel." Yes is fine, but the MS VBO is unable to handle this. Any help would be appreciated! Screenshot attached for assistance. Wed, 23 Aug 2017 20:20:00 GMT IanKelly 2017-08-23T20:20:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66779#M19384 Hi all, I am trying to open a workbook using the Excel VBO "Open Workbook" stage but there is a popup that appears saying "The user has requested that this document be opened as read only." There are buttons to click "yes, no or cancel." Yes is fine, but the MS VBO is unable to handle this. Any help would be appreciated! Screenshot attached for assistance. Wed, 23 Aug 2017 20:20:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66779#M19384 IanKelly 2017-08-23T20:20:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66780#M19385 Hi Kellyia I have encoutered the same issue. I created an object and use Application Modeller to click yes to ensure that the Excel works normally. Then I use MS Excel ""Attach"" to continue the work. Regards Thu, 24 Aug 2017 05:51:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66780#M19385 MetVonghiran 2017-08-24T05:51:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66781#M19386 Hi Kellyia, Metvon works, and alternatively use the global key send, that's what I use. kind regards, Mario Thu, 24 Aug 2017 11:06:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66781#M19386 Mario_pa_sutedj 2017-08-24T11:06:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66782#M19387 Thank you both for the solutions. However, during the open workbook code stage, it waits indefinitely for a button to be clicked, so it will never time out, allowing me to use sendkeys or button click. Any advice? Thu, 24 Aug 2017 21:17:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66782#M19387 IanKelly 2017-08-24T21:17:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66783#M19388 I was able to find a solution. By adding in the lines ""instance.DisplayAlerts = false"" before the open line, I was able to get the file to open normally. Thu, 24 Aug 2017 21:55:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66783#M19388 IanKelly 2017-08-24T21:55:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66784#M19389 Hi Kellyia, i tried to addthe line of code, but it is not helping. Could you please share, if you added that as a separate code action, or within the Open Workbook code stage? Fri, 08 Sep 2017 20:02:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66784#M19389 JosephJohn 2017-09-08T20:02:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66785#M19390 Hi All, I am facing the same issue and pop gives 3 options [update - Don't Update - Help]. I am new to Blue Prism so will appreciate if some one can elaborate the solution. Thanks Nikhil Thu, 14 Dec 2017 15:05:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66785#M19390 NikhilSaini 2017-12-14T15:05:00Z https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66786#M19391 The idea is to add that line in the 'Open Workbook' code stage before the open command Dim app As Object app = GetInstance(handle) app.DisplayAlerts = False 'generally better for RPA as you dont want alerts popping up Dim wb as Object = app.Workbooks.Open(fileName, 0, , , , , True) .... The second parameter means updateLinks set to False, and the True parameter is to set ignoreReadOnlyRecommened=True Thu, 14 Dec 2017 21:52:00 GMT https://community.blueprism.com/t5/Product-Forum/Excel-Open-Workbook-But-Popup-Blocks-It-From-Working/m-p/66786#M19391 Anton__Hosang 2017-12-14T21:52:00Z