cancel
Showing results for 
Search instead for 
Did you mean: 

Open Workbook error

DamianSurlicki1
Level 2
Hi, I am facing a problem with opening Excel. I did a small flow using MS Excel VBO. Workflow consists of 3 objects: 1. Open Instance (Input - whole path of file, Output - handle) 2. Open Workbook (Input - handle, File name whole path of file) -> I am getting error: "Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation." 3. Show (handle) I tried this solution on another PC and it works properly without error message. Could you advise me what is causing this problem and what is the solution? Regards
3 REPLIES 3

TomBlackburn1
Level 7
I usually do Create Instance (rather than open instance) Show Open Workbook

Thanks for your response. I tried with this also but it didn't work. The problem actually is in VBO code object named ""Open Workbook"". Maybe some dll is missing?

check the code stage inside the excel vbo open workbook code stage, i changed it with below code and it worked. Dim wb as Object = GetInstance(handle).Workbooks.Open(filename) name = wb.Name wb.Activate()