Tuesday, February 18, 2014

Macro for batch converting in Excel

Hi folks

Today I needed to batch convert over a hundred Excel file from the old extension (.xls) to the new extension (.xlsx). By far the easiest way was to record a macro while doing one file and then adapting the code to run for all the files in the specific directory.

Here follows the code:

Happy coding!

Hermann

No comments:

Post a Comment