Convert Old Office Files

Robert Ehinger
Robert Ehinger used Ask the Experts™
on
I have recovered about 200 files that were saved in various Microsoft Office 97-2003 formats (.doc, .pub, etc). I need to convert them to Office 2010. When I looked online for a solution I found these steps -

Click the File tab.
On the Info screen, click the Convert button. A descriptive dialog box appears. ...
In the Microsoft Word dialog box, click to place a check mark by the item Do Not Ask Me Again about Converting Documents.
Click the OK button.
Click the Save button to save your document.

The problem is there is no convert button and the page is blamk.

Please advise.

Thank you.

Robert
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
They should just open. They will be DOC, XLS and like format instead of DOCX, XLSX newer formats.  

Word documents may have old images (and unsafe) that you can enable in Word, Options, Trust center but be careful and maybe not use such documents. Similar issues for Power Point.

Just open and good documents will simply open. No overt conversion required. You can save in the new format if you wish
GrahamSkanRetired
Top Expert 2012

Commented:
You don't say to which office version that advice applies. Not 2007 certainly (no 'File tab'), but it might not matter.

If you can open the documents in your current application, the Save As facility should be able to save the document in the latest version. In general you might want to convert from the pre 2007, three letter extension (e.g. .doc) to the 2007 & later, four letter zipped format extension (.docx).
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
Normally there should be a Save As options in which you can select the newer file format (docx, xlsx, ...).
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

EirmanChief Operations Manager

Commented:
You can open a bunch of the old format office files in one go (using Shift & Ctrl Keys).
Close other programs to free up memory if needed.

Then go through them one by using Save As & Close as described in earlier posts.
Then go through the list of files (alphabetically sorted) in file explorer
making sure you have an old & new version of each file.

Then Sort by file type and move all your old file types to a temporary location for later deletion.
Delete the old files when you are happy the conversions.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
You could even automate the process.

http://www.devhut.net/2018/02/27/vba-convert-xls-to-xlsx/

and the same can be done for pretty much any program that can be automated through VBA

Be sure to make a backup copy first, just in case though.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Unless you for some reason need every file in the new format, just open, use and save in the new format as you go. That will do it nicely. I have hundreds of old files I rarely use and just open them when I need to.
>>> "I have recovered about 200 files that were saved in various Microsoft Office 97-2003 formats (.doc, .pub, etc). I need to convert them to Office 2010." <<<

You have stated your requirements very clearly and with no ambiguity i.e. convert 200 pre-2003 files (with three-character file extension) to post-2003 files (with four-character extension).  Clearly you need a bulk/batch process as suggested by Daniel Pineault.  His suggestion uses VBA.
Daniel PineaultPresident / Owner CARDA Consultants Inc.
Distinguished Expert 2018

Commented:
I knew I had a better article and better code, refer to http://www.devhut.net/2018/03/03/vba-convert-file-formats/ which offers you code to handle both Excel and Word files.
Robert EhingerIT specialist

Author

Commented:
I am in the process of trying these solutions. I will let you know how it goes.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial