Link to home
Start Free TrialLog in
Avatar of Robert Ehinger
Robert EhingerFlag for United States of America

asked on

Convert Old Office Files

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
Avatar of John
John
Flag of Canada image

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
Avatar of GrahamSkan
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).
Avatar of Daniel Pineault
Daniel Pineault

Normally there should be a Save As options in which you can select the newer file format (docx, xlsx, ...).
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.
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.
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.
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.
Avatar of Robert Ehinger

ASKER

I am in the process of trying these solutions. I will let you know how it goes.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.