topic RE: Open workbook object issue in Product Forum

Open workbook object issue

NarendranathanS — Fri, 20 Dec 2019 15:01:00 GMT

Dear all,

Excel "Open workbook" object fails to work at code stage.

Here is error prompted when the action is executed.

Can anybody help resolving this issue?

------------------------------
Narendranathan Shanmuganathan
------------------------------

RE: Open workbook object issue

ShailendraSing1 — Tue, 24 Dec 2019 07:52:00 GMT

Hi Narendranathan,

I can see value of HANDLE is ZERO, you need to create instance first to trigger actions of EXCEL VBO. Please use action "Create Instance".

------------------------------
Shailendra Singh
RPA Consultant
GENPACT
Asia/Kolkata
------------------------------

RE: Open workbook object issue

NarendranathanS — Tue, 24 Dec 2019 08:13:00 GMT

Hi Shailendra,

Handle value was not 0 but a non-zero value in my case, it was 1 as expected when I ran the process. You can see the error message and handle value as 1 in the below snippet.

------------------------------
Kr,
Naren
------------------------------

RE: Open workbook object issue

ShailendraSing1 — Tue, 24 Dec 2019 08:57:00 GMT

Original Message:
Sent: 12-24-2019 03:13
From: Narendranathan Shanmuganathan
Subject: Open workbook object issue

Hi Shailendra,

Handle value was not 0 but a non-zero value in my case, it was 1 as expected when I ran the process. You can see the error message and handle value as 1 in the below snippet.

------------------------------
Kr,
Naren