topic RE: Excel error while saving file in .xlsm format in Product Forum

Excel error while saving file in .xlsm format

RajkumarSelvara — Tue, 27 Oct 2020 11:07:00 GMT

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

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

RE: Excel error while saving file in .xlsm format

ritansh.jatwani — Tue, 27 Oct 2020 12:09:00 GMT

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

RE: Excel error while saving file in .xlsm format

RajkumarSelvara — Tue, 27 Oct 2020 13:31:00 GMT

Yes macro is present

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

RE: Excel error while saving file in .xlsm format

david.l.morris — Tue, 27 Oct 2020 15:09:00 GMT

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

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

RE: Excel error while saving file in .xlsm format

AminPatel1 — Tue, 27 Oct 2020 16:52:00 GMT

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=digestviewer&ReturnUrl=%2Fcommunities%2Fcommunity-home%2Fdigestviewer%3FCommunityKey%3D891bbd6b-b97a-418b-a7f5-475cdbcd9ca1

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

RE: Excel error while saving file in .xlsm format

toms1985 — Tue, 27 Oct 2020 17:05:00 GMT

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

RE: Excel error while saving file in .xlsm format

RajkumarSelvara — Wed, 28 Oct 2020 10:05:00 GMT

No issue with path

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

RE: Excel error while saving file in .xlsm format

Mohammed_OmerAl — Wed, 28 Oct 2020 11:38:00 GMT

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

RE: Excel error while saving file in .xlsm format

NileshJadhavBP — Wed, 28 Oct 2020 14:06:00 GMT

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