Excel error while saving file in .xlsm format

[RajkumarSelvara]

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

------------------------------
Rajkumar Selvaradjou
------------------------------

[ritansh.jatwani]

Hi Rajkumar,

Can you please confirm if any macro is available in the excel file which you want to save since without macro, it won't allow you to save the file

------------------------------
Ritansh Jatwani
Consultant
EY
Asia/Kolkata
------------------------------

[RajkumarSelvara]

Yes macro is present

------------------------------
Rajkumar Selvaradjou
------------------------------

[DaveMorris]

Did you verify the path it's trying to write to?

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

[AminPatel1]

This can occur if the directory you are trying to write to does not exist, or if you don't have write access to that directory.

Also kindly refer below post -
https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=83f5c116-2262-4a7f-b980-4f1a7c28515b&CommunityKey=891bbd6b-b97a-418b-a7f5-475cdbcd9ca1&tab=dig...



------------------------------
Amin Patel
Intelligent Automation Developer
Emerson
Pune India
------------------------------

[TomaszSukiennik]

Hi,

Try to duplicate page SaveWorkbookAs  and edit code. Change line
wb.SaveAs(Filename:=filename)
 
to
wb.SaveAs(Filename:=filename, FileFormat:=52)

You could also take file format into variable for support more file extensions.


------------------------------
Tomasz Sukiennik
RPA Developer
Digital Teammates
Europe/Lodz
------------------------------

[RajkumarSelvara]

No issue with path

------------------------------
Rajkumar Selvaradjou
------------------------------

[Mohammed_OmerAl]

Hi Team

Please pass the input as handle and workbook name while using save as action in vbo.

If you are dealing with muliple excel files you will get this error.

Let me know if you have any questions.

Thanks & Regards 

Omer

[NileshJadhavBP]

Hi,

Below link will give you all fileformat number.

https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
ADP
India
------------------------------