topic RE: Excel Close Instance Issue in Product Forum

Excel Close Instance Issue

TruptiKorade — Fri, 09 Dec 2022 16:52:00 GMT

Hi Team,

I am using MS Excel VBO and getting below error message on close instance stage
Close Instance Code ERROR: Internal : Could not execute code stage because exception thrown by code stage: Close Instance took more than 30 secs.

Could you please suggest what could be the reason

------------------------------
Trupti Korade
------------------------------

RE: Excel Close Instance Issue

ewilson — Sat, 10 Dec 2022 00:20:00 GMT

@TruptiKorade,

There have been a few posts about this in the past. As I recall, it can related to closing a really big Excel sheet that's taking a while to write to disk (i.e. save). Especially in cases where the system is already taxed with other processes consuming CPU/RAM.

Is this happening on your local machine while running in debug, or is this on a runtime resource?

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Excel Close Instance Issue

michaeloneil — Sat, 10 Dec 2022 20:35:00 GMT

Hi @TruptiKorade

Have you tried extending the timeout period on the close instance action? I have several processes where the files are very large and take a while to close so I have the close instance set to a longer wait time to allow them to close without error. You can do this in the close instance action as the timeout period is a data item, no messing around the code. Just open the excel vbo>close instance action and then open the Timeout data item and increase the value to the desired period. (See screenshot below). Hope this helps 🙂

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Excel Close Instance Issue

PvD_SE — Mon, 12 Dec 2022 11:26:00 GMT

Hi,

Of course, if the Save or Save As action already worked without problems, you could just ignore the Close Instance crashing and just kill the XL process. This obviously only works, if you only have one XL open at the time.

------------------------------
Happy coding!
---------------
Paul
Sweden
------------------------------

RE: Excel Close Instance Issue

Neel1 — Mon, 12 Dec 2022 12:40:00 GMT

We are following approach given by Michael ONeil . This is common issues for bulky excel.

------------------------------
Neeraj Kumar
Technical Architect
------------------------------

RE: Excel Close Instance Issue

Mjadhav — Mon, 12 Dec 2022 13:27:00 GMT

Hi Trupti,

You can try MS Excel VBO- Exit action to close all the instances of running excel, I find this is very stable and it is the first choice when it comes to close excel.

Thanks
Mayur

------------------------------
Mayur Jadhav
Softeware Engineer
Accenture
Asia/Kolkata
------------------------------