Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2013, 12:41 AM
macropod's Avatar
macropod macropod is offline Is there a way to derive the abbreviation from their full words spelling? Windows 7 64bit Is there a way to derive the abbreviation from their full words spelling? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
Attached Files
File Type: doc AcronymManager.doc (38.5 KB, 55 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 02-14-2013, 03:20 PM
Jamal NUMAN Jamal NUMAN is offline Is there a way to derive the abbreviation from their full words spelling? Windows 7 64bit Is there a way to derive the abbreviation from their full words spelling? Office 2010 64bit
Expert
Is there a way to derive the abbreviation from their full words spelling?
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question

Quote:
Originally Posted by macropod View Post
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.
Thank you very much Pual for sharing the code.

Unfortunately, I couldn’t know how to use it.

Appreciated

Jamal
Attached Images
File Type: jpg Clip_225.jpg (110.4 KB, 58 views)
File Type: jpg Clip_226.jpg (45.6 KB, 56 views)
Reply With Quote
  #3  
Old 06-02-2017, 01:51 AM
WimpievS WimpievS is offline Is there a way to derive the abbreviation from their full words spelling? Windows 10 Is there a way to derive the abbreviation from their full words spelling? Office 2016
Novice
 
Join Date: Jun 2017
Posts: 1
WimpievS is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Hi,
I've been reading to find a solution to a problem. Your macro looks awesome, but I get a run time error. If you can help I will be very grateful!
I have a document with a lot of abbreviations after the full words, e.g. Microsoft (MS) and I'm trying to get a macro to populate a list with the acronym MS and then Microsoft, because after using Microsoft the first time I just use MS throughout the rest of the document. I found an awesome macro, but it works the other way around.
Can you help please?
Reply With Quote
  #4  
Old 06-21-2017, 07:55 PM
macropod's Avatar
macropod macropod is offline Is there a way to derive the abbreviation from their full words spelling? Windows 7 64bit Is there a way to derive the abbreviation from their full words spelling? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by WimpievS View Post
Hi,
Your macro looks awesome, but I get a run time error. If you can help I will be very grateful!
On which line are you getting the run time error?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding All Non-spelling Words in a Paragraph to Dictionary SQLUSA Word 5 07-13-2012 04:05 AM
Why Words doesn’t show the style of the selected words automatically???? Jamal NUMAN Word 0 04-14-2011 03:20 PM
How to take the tick out of Spelling in GPO? Swarv Word 0 09-29-2010 02:16 AM
Automating an address from an Abbreviation Panzer Word 0 04-12-2010 06:11 AM
UK spelling on emails matthew.canwell Outlook 0 06-19-2009 06:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft