topic RE: Error internal save workbook as in Product Forum

Error internal save workbook as

VratHimbo — Wed, 27 Jan 2021 22:00:00 GMT

Hi all,
I've the following error when i try to launch bot from control room
ERROR: Internal : Could not execute code stage because exception thrown by code stage: SaveAs method of Workbook class failed
If i run it from debugger no error appear.
The path is composed by environmentVar &datetime&".xlsx"
Why this occur?
Thanks in advance

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

KrishnaA — Thu, 28 Jan 2021 05:27:00 GMT

Hello Vrat Himbo,

If you have not already tried, suggest testing the process with hardcoded path and file name just to rule out that file path and name aren't the cause of this error.

Best regards,

------------------------------
Krishna A
Blue Prism
------------------------------

RE: Error internal save workbook as

VratHimbo — Thu, 28 Jan 2021 09:04:00 GMT

Hi @KrishnaA,
thanks for reply, i've just tried with hardcoded file path and still the same.
The destination folder exist, the file path is as follows:
EnvironmentVarPath&Datetime&"Report "&FormatDateTime(Now() + MakeTimeSpan(0,1,0,0) ,"dd-MM-yy hh-mm-ss" )"&".xlsx"
What is the possible issue?
Another question: why if i debug a project in case of exception it stop the execution instead if i run from control room keep going?
Thanks

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

KrishnaA — Thu, 28 Jan 2021 09:12:00 GMT

Hi Vrat Himbo,

With regards to your second query, it is the expected behavior. Remember executing from the Control Room is an unattended execution. When executed from the Control Room, the process marks a particular work item as an exception if an error occurs and moves to the next record. This is by design.

Is the expression getting evaluated properly? There is an option to test the value of the expression in the expression builder window. Test and see if the value you are getting is a valid file path and name in Windows.

Hope this helps.

Best regards,

------------------------------
Krishna A
Blue Prism
------------------------------

RE: Error internal save workbook as

VratHimbo — Thu, 28 Jan 2021 09:22:00 GMT

yes @KrishnaA, the expression is valid and if i run from debugger it generate the report in the correct folder.
I've tried to save to desktop folder and not in shared folder, via control room appear error "Microsoft excel cannot access the file" and i put for testing the hardcoded path&test.xlsx, the same, if i try via debugger no error appear and generate the file correctly

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

VratHimbo — Thu, 28 Jan 2021 11:09:00 GMT

This is the error shown:

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

KrishnaA — Thu, 28 Jan 2021 11:45:00 GMT

Hello Vrat,

When you are running from Control Room, which resource you are selecting for the process to run? Is it same as development machine or is it a different resource/system?

Regards,

------------------------------
Krishna A
Blue Prism
------------------------------

RE: Error internal save workbook as

VratHimbo — Thu, 28 Jan 2021 11:57:00 GMT

Same machine as development, i can't understand why this error occur under no circumstances

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

VratHimbo — Thu, 28 Jan 2021 13:37:00 GMT

Up pls

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

VratHimbo — Thu, 28 Jan 2021 15:06:00 GMT

Hi @KrishnaA,
after a lot of attempts I can't even see the file in the network folder, it return false from control room, true from debugger.
I also tried to do shows excel file but in the machine it opens nothing (from control room, from debugger is ok).
The resource name on control room is the same as the vdi, what could be the problem?
Thanks

------------------------------
Vrat Himbo
------------------------------

RE: Error internal save workbook as

KrishnaA — Fri, 29 Jan 2021 04:38:00 GMT

Hi Vrat,

As the error is in the "Save As" action, it could be due to access/file path/naming issues. It requires a detailed investigation. Which Excel VBO are you using? If you are from the customer end, suggest creating a support ticket to investigate the issue in detail.

Best regards

------------------------------
Krishna A
Blue Prism
------------------------------

RE: Error internal save workbook as

sanjayselvaraj1 — Thu, 26 Aug 2021 13:50:00 GMT

Hi Krishna,

I have the same problem.

I am trying to save an excel file to csv.
have created a custom code by making changes to existing save workbook As VBO
below is the line added in my new code :
wb.SaveAs(filename,6)

this method works perfectly fine on debug mode,when tried to run the code in full speed mode /or via control room.

I get an error stating :

Internal : Could not execute code stage because exception thrown by code stage: SaveAs method of Workbook class failed .

I even tried to increase the timeout in the code to 90 seconds and still no luck.

Please let me know what is missing .

Attached are the details.

Excel Version 2016

Thanks

Sanjay

------------------------------
sanjay selvaraj
------------------------------

RE: Error internal save workbook as

BrunoArias — Fri, 18 Mar 2022 11:30:00 GMT

I got the same error, the reason for me was that the directory in which i wanted to store the file didn't exist. So I had to create the directory first

------------------------------
Bruno Arias
------------------------------