topic RE: unable to open MS Excel work book in Product Forum

unable to open MS Excel work book

PratimaShah1 — Tue, 06 Jul 2021 03:00:00 GMT

I don't know why these days I am getting below error whenever I try to open an Excel file.
I have no idea how to fix it. Any help would be appreciated.

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

GuggsKia — Tue, 06 Jul 2021 03:25:00 GMT

Hey Pratima,
As I can see the full path data Item on the left, the path is entered with double quotation mark, can you once remove the double quotation and give it a try?

If this doesn't help, could you post a screenshot of the inputs you're giving to that Action stage please?

------------------------------
Guggs Kia
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Tue, 06 Jul 2021 04:05:00 GMT

Hi Guggs Kia,

I did that but getting the same error.

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

GuggsKia — Tue, 06 Jul 2021 04:48:00 GMT

Request you to please post the inputs of Open Workbook once.

------------------------------
Guggs Kia
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Tue, 06 Jul 2021 05:01:00 GMT

Hi Guggs Kia,

Thank you for your reply.
please find the inputs of 「Open Workbook」

With Regards,
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

michaeloneil — Tue, 06 Jul 2021 07:45:00 GMT

Hi Pratima

The error is being produced by excel not blueprism, if you open file manually do you get any pop up alerts such as requesting you update links or does the file take a very long time to open?

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: unable to open MS Excel work book

krishna.kodimurali9 — Tue, 06 Jul 2021 07:48:00 GMT

Hi Pratima,

Can you try placing the file in any other location other than C drive?

------------------------------
Murali Krishna
RPA Consultant
------------------------------

RE: unable to open MS Excel work book

martin_reuter — Tue, 06 Jul 2021 14:03:00 GMT

Hi Pratima,

we had similar issues with the Excel VBO. I guess that you should remove the Create Instance stage and just open the Excel. If the error remains then check if there are any other instances running (Task Manager). Second, you should check if the Excel is open in another instance, e. g. open the Excel in read only mode.

Kind Regards
Martin

------------------------------
Martin Reuter
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Wed, 07 Jul 2021 02:20:00 GMT

Hi Michael ONeil

Thank you for your reply.
No, I don't get any pop up alerts if I open excel file on my PC, neither it takes long time to open the file.

With Regards
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Wed, 07 Jul 2021 02:22:00 GMT

Hi Murali Krishna,

yes, I tried that, but still getting the same error. Don't know how to resolve.

With Regards
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

krishna.kodimurali9 — Wed, 07 Jul 2021 02:29:00 GMT

Is this issue with that particular file or with every file you are trying to open?

------------------------------
Murali Krishna
RPA Consultant
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Wed, 07 Jul 2021 02:36:00 GMT

Hi Martin Reuter

Thank you for your reply.
I removed the Create Instance stage, but that also didn't help me to fix the error.
I also checked Task Manager and there is no any instance running .
Also there is no Excel open using any other instance.

With Regards,
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Wed, 07 Jul 2021 02:51:00 GMT

With every Excel file I'm trying to open.

With Regards

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Wed, 07 Jul 2021 05:51:00 GMT

The strange part is that the same sinario is working on another PC,
but not working on the PC that I am using.

With Regards
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

michaeloneil — Wed, 07 Jul 2021 07:51:00 GMT

hi pratima

what might help you identify what excel is doing when trying to open the file is after creating an instance add 'Show' action then open workbook. If there are any errors appearing in excel you will see them here.

------------------------------
Michael ONeil
Technical Lead developer
Everis Consultancy
Europe/London
------------------------------

RE: unable to open MS Excel work book

martin_reuter — Mon, 12 Jul 2021 06:56:00 GMT

Please open the object/action and copy/paste the code from the code stage in here...

------------------------------
Martin Reuter
------------------------------

RE: unable to open MS Excel work book

david.l.morris — Mon, 12 Jul 2021 21:07:00 GMT

Did the exact same thing work previously on your machine and then it suddenly stopped working?

If that's the case, first I'll just say that it sounds about right when dealing with automating any Microsoft Office product (through interop). The fact that it works on another PC (I assume in the same Blue Prism environment), then it likely has to do with the Office installation on your machine. I'd be curious to know if the other machine starts showing the same issues at some point which could mean some Windows update that hadn't yet been pushed to the other machine yet. But for sure the first thing I'd try is uninstalling and reinstalling Office.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Mon, 19 Jul 2021 04:22:00 GMT

Hi Michael ONeil,

I've added the 'Show' action before the 'Open workbook' action, but that also didn't help and I am getting error as shown in the image.

With Best Regards
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Mon, 19 Jul 2021 04:28:00 GMT

Hi Dave Morris,

>>Did the exact same thing work previously on your machine and then it suddenly stopped working?

No, It never worked on my PC.

So should I reinstall Office on my PC to fix this problem.

With Regards
Pratima

------------------------------
Pratima Shah
------------------------------

RE: unable to open MS Excel work book

PratimaShah1 — Mon, 19 Jul 2021 04:33:00 GMT

Hi Martin Reuter

Thank you for your reply

>> Please open the object/action and copy/paste the code from the code stage in here...

if I'm not wrong, are you talking about this code?

name = ExecWithTimeout(Timeout, "Open Workbook",
Function()
Dim instance = GetInstance(handle)
Dim workbooks As object = GetProperty(instance, "Workbooks")
Dim wb As Object = Invoke(workbooks, "Open", filename)
Invoke(wb, "Activate")
Return wb.Name
End Function)

Please also find the images of the code of that action

With Best Regards
Pratima

------------------------------
Pratima Shah
------------------------------