Jump to content



Photo

Batch convert XLSM to XLS

excel vba

  • Please log in to reply
1 reply to this topic

#1 Jonny Wright

Jonny Wright

    Love my backups

  • Joined: 13-February 04
  • Location: East Midlands, England

Posted 15 June 2013 - 08:22

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


#2 Kami-

Kami-

    ♫ d(-_-)b ♫

  • Tech Issues Solved: 2
  • Joined: 28-July 08
  • Location: SandBox

Posted 17 June 2013 - 07:08

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.