Open Workbook error
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-09-17 06:24 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
19-09-17 08:46 PM
I usually do
Create Instance (rather than open instance)
Show
Open Workbook
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-09-17 12:27 PM
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?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-10-17 12:42 PM
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()
