<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Open Workbook error in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84513#M35641</link>
    <description>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)
 -&amp;gt; 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</description>
    <pubDate>Tue, 19 Sep 2017 17:24:00 GMT</pubDate>
    <dc:creator>DamianSurlicki1</dc:creator>
    <dc:date>2017-09-19T17:24:00Z</dc:date>
    <item>
      <title>Open Workbook error</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84513#M35641</link>
      <description>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)
 -&amp;gt; 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</description>
      <pubDate>Tue, 19 Sep 2017 17:24:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84513#M35641</guid>
      <dc:creator>DamianSurlicki1</dc:creator>
      <dc:date>2017-09-19T17:24:00Z</dc:date>
    </item>
    <item>
      <title>I usually do</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84514#M35642</link>
      <description>I usually do
Create Instance (rather than open instance)
Show
Open Workbook</description>
      <pubDate>Tue, 19 Sep 2017 19:46:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84514#M35642</guid>
      <dc:creator>TomBlackburn1</dc:creator>
      <dc:date>2017-09-19T19:46:00Z</dc:date>
    </item>
    <item>
      <title>Thanks for your response. I</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84515#M35643</link>
      <description>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?</description>
      <pubDate>Wed, 20 Sep 2017 11:27:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84515#M35643</guid>
      <dc:creator>DamianSurlicki1</dc:creator>
      <dc:date>2017-09-20T11:27:00Z</dc:date>
    </item>
    <item>
      <title>check the code stage inside</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84516#M35644</link>
      <description>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()</description>
      <pubDate>Fri, 13 Oct 2017 11:42:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Open-Workbook-error/m-p/84516#M35644</guid>
      <dc:creator>ekinsuugur</dc:creator>
      <dc:date>2017-10-13T11:42:00Z</dc:date>
    </item>
  </channel>
</rss>

