Originally Posted by macropod

Hi Jamal,

1. No.

2. Your second screenshot suggests you're trying to call the macro via a link that points to the 'ThisDocument' module in your 'Document1', not in the 'Acronym Manager'. Try activating the document you want to update, then press F11 and run the macro directly from the vbe. As you've noted, the code also provides a means of running it from a different document to the one your list is in. That means you could add it to Word's 'Normal' template and run the macro from there simply comment out the 'Set FRDoc = ThisDocument' line and un-comment the 'Set FRDoc = Documents.Open' line and update the file reference there to point to whever you want to keep your own list (just make sure that document doesn't have any macros).

3. Aside from adding the code to your 'Normal' template, you could keep the file in a 'trusted location'. See: http://office.microsoft.com/en-us/he...010031999.aspx

Originally Posted by macropod

Jamal,

You do not need to copy the code to your file. Simply open the 'Acronym Manager' document, switch back to the document you want to process, press Alt-F11, then click on the 'Acronym Manager' macro in the the 'Acronym Manager' document's 'ThisDocument' module and press F5.

The only reason for copying the 'Acronym Manager' macro anywhere is to copy it to the document template (eg Normal.dotm) so that you can use it via Alt-F8 - with the acronym/abbreviation list stored in a separate document that the macro calls.

Originally Posted by macropod

Have you added and entry for “National Spatial Plan <tab> NSP” to the 'Acronym Manager' document? I don't see any evidence of it in your screenshots.

Originally Posted by macropod

In your modified 'Acronym Manager' document, it appears you have a space after 'Plan'. Since your test document doesn't have the space, the expression won't be found. Suggested solution: delete the space after 'Plan'.

Originally Posted by macropod

Try the attached document. It contains both an acronym/abbreviation list (that you can edit) and a macro (AcronymManager) to process any acronyms/abbreviations in whatever is the active document. The basic requirement for list management is that each entry be a separate paragraph, with the full expression listed first, followed by a tab then the acronym/abbreviation. Of course, you also can't have two entries with the same acronym/abbreviation.

The code includes comments to show how a separate document might be used for the acronym/abbreviation list instead of the one in the attachment. That might be useful if you were to add the macro to Word's Normal template.

How it works:
Basically, the macro uses a loop to call a series of Find/Replace operations to edit the text in the target document, replacing all occurrences of a given expression and its acronym/abbreviation with just the acronym/abbreviation and, for the first occurrence only, both the full expression and the acronym/abbreviation, the latter enclosed in brackets.

Originally Posted by WimpievS

Hi,
Your macro looks awesome, but I get a run time error. If you can help I will be very grateful!