Batch convert XLSM to XLS

[Jonny Wright]

I have a load of XLSM files which I need to convert to a "regular" Excel format such as XLS. Just renaming the files is not appropriate as the XLSM files have VBA which runs when the workbook opens and what I am trying to do it effectively remove the VBA functionality of all the files so that once they are converted, the VBA will not run when the workbook is opened.

Thanks

[Kami-]

You could try to rename them as xslx (non macro enabled workbook) - that might work, I've not tried it.

 

XSLM(XSLX) use an XML format for storage - where-as XLS uses binary therefore the only way to batch convert them would be a script/utility to open them and resave them in the alternative format.