Smart update tutorial for old Office documents

Microsoft stopped supporting Windows XP and Office 2003 software in April 2014. Most users have upgraded to Office 2007 and even the latest 2013 version. Older versions of Office files use binary files, which are opened in compatibility mode in the new version of Office, and there may be problems. How do you convert these legacy files to a new version of the Open XML format? [Solutions] One of the easiest methods is to open the old Office document in the new version of Office, and then save it as a new version of the document through the "Save As" dialog box. However, when there are a lot of documents to be converted, this method is too cumbersome, and you can use the tools provided by Office 2013 to quickly convert. [Solution method] Use "dext" to achieve one-click update If only a small amount of Office documents, you can achieve a one-click conversion by "transform", here is the Excel 2013 version as an example. Load the Excel workbook in the old version format. At this time, the file name of the title bar is displayed with the words "Compatibility mode". Switch to the "Files" tab, select "Info" in the left navigation pane, click the "Convert" button in the right pane, a dialog box will pop up (Figure 1), click “ OK & rdquo; quickly complete the automatic conversion. Batch update with OFC If you need to convert multiple old format Word documents into a new version format, using the above method is not a hassle. In this case, you can use the official OMPM tool to achieve batch conversion. First download the OMPM toolkit from http://tinyurl.com/8y6sb9v and unzip it. Note that you need to install the Microsoft Office Compatibility Pack on the computer containing the file to be updated before downloading (download address: http://tinyurl.com/72vkdpc) . Go to the OMPM extraction folder and find the Ofc.exe command line tool in the Tools directory. Refer to the built-in Ofc.ini file for related settings, there are many setting items, but we only need to pay attention to two aspects: 1. Specify the location of the file to be updated: find the [FoldersToConvert] section, follow “fldr=\\\\server\\share\\ Add the appropriate content to the docs” format, for example, “fldr=e:\\Temp\\temp1\\” (Figure 2). 2. Specify the output location after the update: By default, after the update, OFC will store the update file in the Converted directory of the current path. If you need to re-specify the location, you can find the [ConversionInfo] section and change “DestinationPathTemplate=&rdquo The content behind, of course, can also be changed without using the default settings. Complete the above changes, enter the command prompt environment, execute the ofc.exe command (note the command path), and wait a short while to complete the task of batch updating the file format (Figure 3). Of course, in addition to the above methods, you can also consider using the VBA method to achieve, here is not introduced one by one.