For the process that I deal with ODC files, I open the ODC using the Open Workbook action like as described above.

I'm not sure if I entirely get what you mean by trying to save/get into a collection with the ODC itself. You might be fine with the default setting if it takes about 2 minutes. I can't remember what the default was, to be honest, but I have it for 600 seconds, as my process transfers data from multiple SharePoint sites which slows it down somewhat. Yeah, that's what I do - I point the Open Workbook action to the ODC file, and the Open Workbook action doesn't complete/move on to the next action until the data is populated in an active Excel session.Īs far as extending the Time Out variable, it's just a case of viewing the Open Workbook action within the Excel Object and changing the Timeout value (in seconds). Currently my file takes around 2 mins to open excel manually. Thank you for the reply, so if i open the file using ms excel VBO open work book will populate the values?, pls can you tell me how to extend the time out variable. Please can some one suggest what is the best way to open ODC extension file using blue prism I have the power query set up in a ODC file, i tried using ms excel VBO to open the file by in blue prism i get error saying the collection not available. Let me know if you need any further assistance. Depending on the size of data or the complexity of the query, you might need to extend the Timeout variable within the Open Workbook action. Within Blue Prism, using the latest Excel VBO, I point the 'Open Workbook' action on the ODC file and it then populates. I take it that you have created the Query in Power Query and exported the connection to create the ODC file? I run a similar process that uses ODC files. Subject: open ODC extension file with power query using blue prism

Open power query in excel