topic RE: Error when opening a XLSM file in WIN 7 in Product Forum

Error when opening a XLSM file in WIN 7

CristianHerrero — Wed, 09 Sep 2020 12:11:00 GMT

Hi,

I'm using in process the save excel file as XLSM with the code wb.SaveAs(filename,52). I have no issue when I open the file using Windows 10, the macro works as intended; however when I try to open it using Win7 the file gets stuck and I need to reset Excel.

Any idea?

Thanks a lot

------------------------------
Cristian Lopez
RPA configurator
Volvo Cars
Europe/London
------------------------------

RE: Error when opening a XLSM file in WIN 7

shashank.kumar280 — Thu, 10 Sep 2020 13:42:00 GMT

Hi Cristian,

Do you have the same version of Excel in Win10/Win7? Is there any content in the Excel file which is incompatible with the MS Office version that you have in Win 7? Also do you get the same issue when you perform the steps manually?

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Error when opening a XLSM file in WIN 7

CristianHerrero — Fri, 11 Sep 2020 06:24:00 GMT

Hi Shashank,

The Excel version are not the same in WIn7 and Win10. I created a new macro in Win7 and now it works perfectly.

Thanks four your input!

------------------------------
Cristian Lopez
RPA configurator
Volvo Cars
Europe/London
------------------------------