converting excel files to new version
 

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

converting excel files to new version
 

Old version/format ?
New version/format?
Try opening in new versionsave.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kenwhoever" wrote in message
...
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??

converting excel files to new version
 

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/Sho...94700&SiteID=1




"Don Guillett" wrote in message
...
Old version/format ?
New version/format?
Try opening in new versionsave.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kenwhoever" wrote in message
...
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??

converting excel files to new version
 

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Teneo" wrote in message ...
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/Sho...94700&SiteID=1




"Don Guillett" wrote in message
...
Old version/format ?
New version/format?
Try opening in new versionsave.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kenwhoever" wrote in message
...
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??