

Try the macro from Graham Mayor in that thread as a starting point. Most are written for Word but can be easily adapted for Excel or PowerPoint. They automate the process of opening then Save As for a folder full of documents. There are many VBA macros out there that will handle conversion.

It works on Office 2007, 20 – probably Office 2016 too. We’ve not tested this tool but NCH can usually be relied upon.īatch Process Documents is a collaboration of Greg Maxey with Doug Robins and Graham Mayor. One bulk-conversion tool you might like to try is Doxillion from NCH Software. Preparing for document conversionīefore you do any document conversions – backup, backup, backup.Īssume something will go wrong with the conversion and prepare accordingly. Conversion of existing old documents isn’t essential. You can check each conversion right away to see if there’s any problems. Long time users may remember the many times that Microsoft have promised easy file conversions only to be disappointed in more complicated situations.Īll said, individual conversion is preferable. When you’re talking about hundreds or thousands of files, that takes up a lot of time.Īny conversion is likely to have problems with more complex documents. It should use your most recent version of Word, Excel, PowerPoint to open each document then Save As to the new format. What if the password doesn’t meet the newer password standards? The complications go on and on ….īulk conversion is also time/resource consuming. Get the password to read the existing document and, optionally, save the new document with the same password. Any full featured bulk conversion tool would have to somehow cope with password protected documents. It’s often the case that a seemingly simple job gets more complicated as you dig into details.

The safer corporate choice was to leave the problem to customers. The bad PR would have spoiled their push of the new document formats. If their conversion tool had messed up formatting or removed data, they’d have had a lot of unhappy customers. Microsoft made a doc to docx bulk converter but it’s difficult to use and best avoided.
