Error Invoke Code

[supermanPunch (Arpan)]

@pdcampagnini

Invoke Code: Exception has been thrown by the target of an invocation.

Hi @pdcampagnini ,

We would need to Handle the Exceptions happening inside the Invoke Code Activity with a Try Catch Block as mentioned in the post below :

Invoke code - Exception has been thrown by the target of an invocation

Hi @Sirisha_Siri , To understand more about the error being faced inside the Invoke Code, try using Try Catch Block inside it like the below Updated Code. We would require to handle the Exceptions inside Invoke Code Activity to be able to understand where/what was the exact error. Try Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook xlApp = New Microsoft.Office.Interop.Excel.Application wb = xlApp.Workbooks.Open(in_FilePath) xl…

@pdcampagnini

What’s the best way to share the code with you?

If the Code Snippet is short, you could share it here as an Image or inside the Preformatted Text (</>). So we can have a proper visibility of the code along with it’s format.

If the Snippet is longer than usual, you could share it via a text file.

Do let us know about the code snippet and if you were able to implement the Try Catch block.