MS Excel VBO exception

[AnatoliyBanniko]

Hi, I have faced strange issue. Yesterday Excel vbo Open workbook and write collection worked perfectly but today everything has changed 😕 I was working on Dev2 final assignment and during the creation of process for reporting i faced issue of getting exceptioin at write collection stage. Exception was " Exception has been thrown by a traget invocation." Im trying to solve this issue all day but i simply donot understand the problem, i dont see it. Did anyone encounter that? What could be the problem and solution? Thank you in advance!

[Denis__Dennehy]

Which version of office are you using? Blue Prism is not yet certified for Office 16/365. I ask because I have interfaced with every version of Excel from 2000 and 2013 and have never seen that error.

[AnatoliyBanniko]

Deplorably, I am using 2013 version. I thought that when i was changing import CSV action in that VBO for my purposes, i broke something. (import csv works fine, though, still) I re-imported original MS Excel VBO, didnt help. Asked DWF IT to help, still waiting for an answer.

[AnatoliyBanniko]

Excel produces exception when code tries to interact with the cells. In particular, when its trying to use SetProperty function to write collection into cells. Although, i tried to use Set Cell Value action, it sets the cell value(e.g. col * row item) and then produces the exception. This is confusing.

[AnatoliyBanniko]

Basic computer restart solved the problem. ;D