Error internal save workbook as

[VratHimbo]

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
------------------------------

[KrishnaA]

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
------------------------------

[sanjayselvaraj1]

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
------------------------------

[BrunoArias]

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
------------------------------