I am trying to do a mass conversion of our Word and Excel documents from the 2003 format to the office 2010 file formats. There are about 3500 docs that I am looking to convert.
I have managed to create this macro which converts Word docs fairly quickly on a 1-by-1 basis without the extra prompts, but I would love to expand the code to do it for entire directories at a time (even better if it would do it recursively for subfolders).
I am not as familiar with VBA as vbscript and am having a hard time doing this. Can anyone help?
OriginalFileName = ActiveDocument.Name
Path = ActiveDocument.Path
NewFileName = OriginalFileName & "x"
ActiveDocument.SaveAs2 FileName:=NewFileName, FileFormat:= _
wdFormatXMLDocument, LockComments:=False, Password:="", AddToRecentFiles _
:=True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts _
:=False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
WholePath = Path & "\" & OriginalFileName
I have played with the Microsoft OMPM converter utility
, but although this seems to convert doc's and xls's to docx's and xlsx's, it seems to put them into 2007 version. When you open them in 2010 it still says "Compatibility Mode" at the top. So this is not a good solution for me.