Batch convert XLSX to XLS with VBS
17 февраля 2010, 05:54:59
If you have Excel 2007 installed and you are looking for a way to convert XLSX ->XLS using windows shell (batch script, etc.) here’s the perfect solution:
1) copy this code and save it is as xlsx2xls.vbs OR simply download it
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open(Wscript.Arguments(0))
objExcel.Application.Visible = False
objExcel.Application.DisplayAlerts = False
objExcel.ActiveWorkbook.SaveAs Wscript.Arguments(1), 56
objExcel.ActiveWorkbook.Close
objExcel.Application.DisplayAlerts = True
objExcel.Application.Quit
WScript.Quit
2) in [...]
|