I need a tool to convert MS Word & MS Excel files to new 2013 version

I'm looking for a tool to convert MS Word (.doc) to .docx and MS Excel (.xls) to .xlsx - has anyone got any experience of this. I need to do a few thousand at once.

Thanks
LVL 3
James NewportAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gowflowCommented:
Don't understand your question

if you have .doc and .xls files this means they are in Office 2003 and earlier if you want them to be converted to .docx and .xlsx meaning to 2007 later versions then simply open blank Word or Excel new version and from the File Open menu choose your .doc or .xls file and choose Save as and make sure in the file type to choose the new .docx or .xlsx type and here you go they are converted.

gowflow
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I haven't used it myself, but Office Migration Planning Manager of http://www.microsoft.com/en-us/download/details.aspx?id=11454 contains a tool called OFC.exe to perform bulk converts. You'll have to edit OFC.INI to contain all necessary folders and settings, and then up you go. For a short usage example see http://blogs.msdn.com/b/ericwhite/archive/2008/09/19/bulk-convert-doc-to-docx.aspx.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
yo_beeDirector of Information TechnologyCommented:
To add to the above comment you would be creating a new file for each of these dated Office file.
This would give them all new Time Stamps and you would have duplicate files.

It does mot hurt to have the old files remain as they are (2003 format) and moving forward all new files will be using the *.DOCX or *.XLSX.  

Office 2013 can read 2003 files perfectly fine.

If you did want to do something you could script something like powershell, but I think it is a waste of time and effort.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I don't know if the Tools takes over the creation and modification time stamps of the original file. If not, PowerShell can be applied after the fact.
0
kulboyCommented:
you can automate the process with a macro e.g. as . Put all the documents that you wish to convert into a folder and run the macro. Select the folder you have used to store the documents. Note that the macro as written will not work with password protected documents.
 
Sub SaveAllAsDOCX()
Dim strFilename As String
Dim strDocName As String
Dim strPath As String
Dim oDoc As Document
Dim fDialog As FileDialog
Dim intPos As Integer
Set fDialog = Application.FileDialog(msoFileDialogFolderPicker)
With fDialog
    .Title = "Select folder and click OK"
    .AllowMultiSelect = False
    ..InitialView = msoFileDialogViewList
    If .Show <> -1 Then
        MsgBox "Cancelled By User", , "List Folder Contents"
        Exit Sub
    End If
    strPath = fDialog.SelectedItems.Item(1)
    If Right(strPath, 1) <> "\" Then strPath = strPath + "\"
End With
If Documents.Count > 0 Then
    Documents.Close SaveChanges:=wdPromptToSaveChanges
End If
If Left(strPath, 1) = Chr(34) Then
    strPath = Mid(strPath, 2, Len(strPath) - 2)
End If
strFilename = Dir$(strPath & "*.doc")
While Len(strFilename) <> 0
    Set oDoc = Documents.Open(strPath & strFilename)
    strDocName = ActiveDocument.FullName
    intPos = InStrRev(strDocName, ".")
    strDocName = Left(strDocName, intPos - 1)
    strDocName = strDocName & ".docx"
    oDoc.SaveAs FileName:=strDocName, _
        FileFormat:=wdFormatDocumentDefault
    oDoc.Close SaveChanges:=wdDoNotSaveChanges
    strFilename = Dir$()
Wend
End Sub
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.