VBA - Word 2007 - Corrupt .doc files

[ian]

We have a set of macros written in VBA for Word 2003. These macros automated
the saving of the associated document, creating a filename and an entry for
the document in a register (which is also a Word document).

In Word 2007 the macro runs but the document and registry are unreadable in
Word 2003 even though the file extension is .doc. Word 2003 reports that it
will need to install filters to read the document. The only solution is to
open the documents in Word 2007 and save them in compatibility mode.

Even setting Word 2007 to save in compatibility mode by default does not
solve the problem. Have also tried installing the 2007 compatibility pack
for Word 2003 but this also does not solve the problem.

Does anyone know what is going, or have a possible solution?

Thanks

Ian

 

[tshades]

Hey Ian,
I've seen something like this before. Sounds like your actually saving
the Word 2007 document in the DOCX format even thought you have set the
extension to DOC. Office 2007 doesn’t care about the extension but 2003 does.
So when you try to open the documents in Word 2003 they look corrupt even
thought they open fine in 2007. Sounds like you need to set the save format
in your macro. I'm not sure if this is your issue but it sounded very close
to an issue I ran into a year or so back.

I'm sure you have solved this by now your self.