Your company's ad could live here and reach over 50,000 people a month!

Author: N. Moseley

Script to Convert XLS to XLSX

Wrote this little diddy to convert an Excel 2003 file to Excel 2010 file. ' Const xlExcel12 = 50 Set oExcel = CreateObject("Excel.Application") ' Set below value to false to hide the Excel window oExcel.Visible = True ' Convert Set oWorkbook = oExcel.Workbooks.Open("C:\filename.xls") Set oWorksheet = oWorkbook.Worksheets(1) oWorkbook.SaveAs ...