topic Issue with MS Excel VBO 10.1.11 in Digital Exchange https://community.blueprism.com/t5/Digital-Exchange/Issue-with-MS-Excel-VBO-10-1-11/m-p/109122#M3415 <P>Good day all,<BR /><BR />Believe I found a rather annoying issue with MS Excel VBO 10.1.11.<BR />The Write Collection (Fast) action to be specific.<BR /><BR />When attemping to write a collection to a spreadsheet, if the collection is blank, you will recieve the super generic "<SPAN>Exception from HRESULT: 0x800A03EC".<BR /><BR />I was able to work around this issue by checking the number of rows in the collection before attempting to write the collection to a spreadsheet.</SPAN></P><P><SPAN>My question is as follows:<BR />Why are blank collections not catered for in the VBA code??<BR />This seems like a rather large oversight.<BR /><BR />Can this please be addressed in the next version of the Excel VBO.<BR />Hopefully this post will save someone the few hours I spent trouble shooting this issue.</SPAN></P> Tue, 02 Apr 2024 13:08:32 GMT ShoeLase101 2024-04-02T13:08:32Z Issue with MS Excel VBO 10.1.11 https://community.blueprism.com/t5/Digital-Exchange/Issue-with-MS-Excel-VBO-10-1-11/m-p/109122#M3415 <P>Good day all,<BR /><BR />Believe I found a rather annoying issue with MS Excel VBO 10.1.11.<BR />The Write Collection (Fast) action to be specific.<BR /><BR />When attemping to write a collection to a spreadsheet, if the collection is blank, you will recieve the super generic "<SPAN>Exception from HRESULT: 0x800A03EC".<BR /><BR />I was able to work around this issue by checking the number of rows in the collection before attempting to write the collection to a spreadsheet.</SPAN></P><P><SPAN>My question is as follows:<BR />Why are blank collections not catered for in the VBA code??<BR />This seems like a rather large oversight.<BR /><BR />Can this please be addressed in the next version of the Excel VBO.<BR />Hopefully this post will save someone the few hours I spent trouble shooting this issue.</SPAN></P> Tue, 02 Apr 2024 13:08:32 GMT https://community.blueprism.com/t5/Digital-Exchange/Issue-with-MS-Excel-VBO-10-1-11/m-p/109122#M3415 ShoeLase101 2024-04-02T13:08:32Z