converting excel files to new version

[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??

 

[Don Guillett]

Old version/format ?
New version/format?
Try opening in new version>save.

 

[Teneo]

Nice one Don, but opening and 'save as' for thousands... very time
consuming...

Good point, what version to which version...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2794700&SiteID=1

 

[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