ods to xls file conversion

[ikshanu]

Hi,

Please help to create a code for converting .ods file to .xlsx from a folder

[macropod]

Is there a reason you can't simply open the file and re-save it using SaveAs?

[ikshanu]

Dear.Mr Paul Edstein

There are lot of .ods files.It is difficult to open whole files and save as to .xlsx.That's the reason

[macropod]

In that case, you could use a macro like:

Please Login or Register  to view this content.

The macro includes a folder browser, so all you have to do it to select the folder and all .ods files in it should be converted to the .xlsx format.