Macro to create a copy of XlSB file and save as XLSX file without any formulas.

[Mysore]

Hi Guys

I'm trying to create a copy of an XLSB excel file to XLSX file with the help of a macro. The Source file has pivot table and datasheets.
Below is the code which I found on the net but apparently the code debugs with Run time error 1004 Method 'copy of object'_worksheet failed @ the line Sh.copy
Any help to correct the same is appreciated.

Thanks

Please Login or Register  to view this content.

[Alf]

I think I would just open the xlsb file, loop through all sheets and convert formulas to values and then save the xlsb file as an xlsx file. A macro like this should be sufficient so put this macro in an Excel file and change "sPath" to suit your needs.

Please Login or Register  to view this content.

Any bells and whisles you wish to add can be done if this looks like a workable solution to you.

Alf