How to Open Repairable Excel File with Blue Prism

[_Amlansahoo]

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

[david.l.morris]

Does it have this error when you open it manually?

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

[_Amlansahoo]

Yes Dave. Manually also same error is there.

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

[VivekGoel]

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

[_Amlansahoo]

Hi Vivek,

Thanks for your great help ;-).


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