You should be able to do that by changing:
Sub CreateAcronymAppendixDocument()
to:
Sub Document_Open()
and putting the macro in the Acronym document's own 'ThisDocument' code module. Your error messages suggest you might have been adding the macro to Word's Normal template.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]