converting excel files to new version

K

kenwhoever

Our company has thousands of excel files. 99% of them are under old formats.
How can convert them to our current version in mass or as a batch??
 
R

Ron de Bruin

You can use a macro that open all workbooks and do a saveas to
the new format.

I assume you have 97-2003 files and want to save them as 2007 files
Do you want to save as xlsx or xlsm ?

Let me know and I will post a example this evening
 
Top