| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
| links between 2007 version files and 97-2003 version files | Links and Linking in Excel | |||
| Converting Adobe files into Excel files | Excel Discussion (Misc queries) | |||
| French Version of Excel saving CSV Files with a semi-colon | Excel Discussion (Misc queries) | |||
| Converting CSV files into Excel files | Excel Worksheet Functions | |||
Linear Mode
