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

vivek.kumar.goel — Sat, 23 Nov 2019 06:26:00 GMT

xls file have this problem.

I suggest you to write a macro to convert xls to XLSX and then run the macro using BP. Which will solve your issue.

There may be many more options, but this one I felt as the best one.

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

RE: How to Open Repairable Excel File with Blue Prism

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

Okay Thanks Vivek for your suggestion.

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

RE: How to Open Repairable Excel File with Blue Prism

vivek.kumar.goel — Tue, 26 Nov 2019 04:30: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

Thanks Vivek, it helps a lot. 😉

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

RE: How to Open Repairable Excel File with Blue Prism

_Amlansahoo — Tue, 28 Jan 2020 12:44:00 GMT

Hi Vivek,

When I tried using this Converter manually it's not working.
I have created .xls and tried to convert it to .xlsx file. But it did not work at all.
It is working on a different way means if I am having a file with .xlsx it's converting to .xls file.

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

RE: How to Open Repairable Excel File with Blue Prism

RaviTeja — Tue, 04 Feb 2020 07:03:00 GMT

Hi Amlan,

I have checked the macro code and observed that it is converting xls files to xls files only.

I modified macro code which will convert xls to xlsx format. Do check and let me know if face any issues.

Thanks!
Ravi Puvvula

------------------------------
Ravi Teja
RPA Developer
Accenture
Asia/Kolkata
------------------------------

RE: How to Open Repairable Excel File with Blue Prism

PradeepNagineni — Wed, 07 Oct 2020 04:26:00 GMT

Hi Guys,

I have been facing the same issue. I download a repairable .xlsx file everytime from browser, but cannot open the repairable file with BP.

Can you help me out with this issue.

Thanks in Advance!

------------------------------
Pradeep Nagineni
------------------------------

RE: How to Open Repairable Excel File with Blue Prism

NicholasZejdlik — Wed, 07 Oct 2020 13:24:00 GMT

Take a look at the Workbooks.Open method, there's an optional parameter on there for CorruptLoad, which you can use to open the Excel file in repair mode. I believe it should remove the prompt that you're seeing.

I would duplicate the existing Open Workbook page in Blue Prism, then alter the code stage to look like this:
Const xlRepairFile As Integer = 1
Dim wb as Object = GetInstance(handle).Workbooks.Open(FileName:=filename, CorruptLoad:=xlRepairFile)
name = wb.Name
wb.Activate()

------------------------------
Nicholas Zejdlik
RPA Developer
------------------------------