Convert to Strict Using Excel Macro - Asbjoedt/CLISC GitHub Wiki

It is possible to bulk convert spreadsheets to .xlsx Strict conformance by using a macro in Excel. Here you can download an example of a macro, which saves each spreadsheet from the input directory in an output directory and converts them to .xlsx Strict and renames each spreadsheet n+1.xlsx. Essentially, only one line of code does the conversion, which you can find below, however to make the macro perform as intended, several more lines of code are necessary.

VBA convert to .xlsx Strict code

Workbook.SaveAs filename:=new_filepath, FileFormat:=61

Download spreadsheet with macro to bulk convert spreadsheets to .xlsx Strict.