topic RE: How to Open Repairable Excel File with Blue Prism in Product Forum

How to Open Repairable Excel File with Blue Prism

_Amlansahoo — Fri, 22 Nov 2019 12:55:00 GMT

Hi Folks,

How to open repairable excel files using Blue Prism. For now when I am trying to open it's throwing error.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: How to Open Repairable Excel File with Blue Prism

david.l.morris — Fri, 22 Nov 2019 17:31:00 GMT

Does it have this error when you open it manually?

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: How to Open Repairable Excel File with Blue Prism

_Amlansahoo — Mon, 25 Nov 2019 06:36:00 GMT

Yes Dave. Manually also same error is there.

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------

RE: How to Open Repairable Excel File with Blue Prism

vivek.kumar.goel — Mon, 25 Nov 2019 09:06:00 GMT

Here is the macro which you may want to use for converting the xls to xlsx . Once done, you can easily open and do whatever you want on your xlsx file 🙂

Hope it helps.
Steps:
1- Create an instance, open the converter.xlsm, Write the name of xls file in A2 of this converter of xlsm file attached.

2- Once done, us e the run macro action to run the macro named "ConvertToXLS"
3- It will save the file in xlsx format for you to use further.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
+6594554364
https://www.rpatools.com/
------------------------------

RE: How to Open Repairable Excel File with Blue Prism

_Amlansahoo — Tue, 03 Dec 2019 06:46:00 GMT

Hi Vivek,

Thanks for your great help ;-).

------------------------------
Amlan Sahoo
RPA Consultant
Equinix
------------------------------