Convert Xls To Xlsx File Without Opening
I have to work with an old application that can only export XLS files and I write programs in .Net using the EPPlus library that is only capable of reading XLSX files.
The File Format Converter utility of Kutools for Excel aimed to batch convert multiple files between xlsx and xls formats, or convert Excel files to PDF files. Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.
What is the easiest way to batch convert from XLS to XLSX?
OriginOrigin5 Answers
Check out Office Migration Planning Manager.
The toolkit also contains the Office File Converter (OFC), which enables bulk document conversions from binary to OpenXML formats. (Technet)
I'd recommend using a macro to process the files within a folder to convert them from xls to xlsx. This code assumes that the files are all located within one folder and that all xls files need to be converted, but if you wanted to select individual files this code could be updated.
This code would need to be run from an Excel 2007 or Excel 2010 workbook.
If the files you are converting contain macros then you would need to update the 'FileFormat:=51' to read 'FileFormat:=52'. Or if you don't need to macro code in the converted files you could leave it alone and it will remove the macros when it converts it to the xlsx format.
Convert Xls To Xlsx File Without Opening A Business
If you have MsOffice installed, then this tool might be worth a download for a quick fix.
When you select a folder to see the xls files converted, make sure you tick the convert tool option that uses MS Office to the conversion, not their own converter.
If you use their own converter you will lose colors in the cells and single sheet seems to come out.If you use the MsOffice as the converter seems to work nicely.Good tool for a quick fix.
So I wrote a simple VBScript to convert .xls files to .xlsx in a silent fashion.
convert-xls-xlsx.vbs :
NOTE: Look out for spaces in the folder path, if your path has a space in between, put the path in quotes.
Batch Convert Xls To Xlsx
Not the answer you're looking for? Browse other questions tagged microsoft-excelconversion or ask your own question.
I have to download files from a database and save them in .xls format (the only format permitted to export from the database)
Anyone have a macro to:
Given an open excel wb saved to my hard drive (or network drive) in non .xlsx format. (most likely .xls)
Switch the file to .xlsx format without loosing the open file. (re-open ok).
Caveats:
-Don't want two files
-Dnn't want to have the file name changed (except for the extension).
-Don't want to remain in compatibility mode.
-Don't want to wait a long time.
-Don't want to have possibility of file corruption.
I just want to take my non .xlsx file and then, turn into a .xlsx file. (if I save the file as .xlsx I am still in compatibility mode until I re-open the file. I also will have two files---very annoying).
Thanks in advance