Using Word 2003 Macro document with Word 2007

[Vengeance52]

Hi all,

new member but this seems to be the place to get some answers

I created a Word 2003 document, that is used as a template for filling
out personal details and that contains various macros during doc open,
various changes and doc close.

This document is to be used by multiple users and when a user fills the
doc out, they save it in the same directory with a new filename.

This docuemnt is then reviewed by myself using word 2003

The issue is, that when a user who has Word 2007 open and saves the
document, the document is being saved as a .docm document and when I
open this, the macros dont work correctly and I get a runtime error.

Now I have put in some Application.DefaultSaveFormat = "DOC" coding
into VB, which stops the error from appearing as the new saved document
is saved as .doc.

The only problem, is the macro that runs when the document closes,
doesnt seem to work for 2007 users when saving as .doc

Anyone have any ideas?

 

[Beth Melton]

This isn't exactly the answer you are looking for but it's the "correct"
answer. What you really need to do is use a real template and store your
macros in it. Then when you create new documents based on the template the
macros aren't saved in the resulting document. Instead, the document will
look to the template and use the macros stored in it.

I don't know what your macros actually do, such as the one that should run
when the document closes or how it runs, but if the macros are stored in a
template I suspect it would resolve the issue you are currently
encountering.

~Beth Melton
Microsoft Office MVP

 

[b_darren]

I'm running into the same problem and I am using a Word template (*.dot)
file.
(I assume this is a real template you refer to Beth?).

I have many Macros that determine what data to display in the
Header/Footer area
depending on page numbers, forms items and updateable bookmarks. These
are updated
manually via another macro.

When opened in Word 2007 I'm gettin repeating text across my pages.

Anyone have a solution, It seems strange that Word 2007 would not be
backward compatible.

Kind thanks
Darren