MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Phil    Date: Feb 16    Category: MS Office    Views: 1587

May I get list of Auto-Correct entries automatically in the shape of a



3 Answers Found

Answer #1    Answered By: Feodora Bonkob     Answered On: Feb 16

Assuming we're talking excel autocorrect entries  here:
these two lines in a macro will get you a list  of entries and
replacements in columns A and B of a worksheet:

repl = Application.AutoCorrect.ReplacementList
Range(Cells(1, 1), Cells(UBound(repl), 2)) = repl

it's up to you to save this as a csv file, or to cut'n'paste it etc
to create a document.

If we're talking word autocorrect entries, then a macro in word with
these lines sort of works (I'm not Word vba literate so forgive if
it's not especially elegant):

For Each Item In Application.AutoCorrect.Entries
ActiveDocument.Content.InsertAfter Text:= _
Item.Name & ", " & Item.Value & vbLf
Next Item

Answer #2    Answered By: Della Simpson     Answered On: Feb 16

Excel shares AutoCorrect entries  with the other Office apps.
Particularly if you want your output as a document, I'd ask this
question in a Word VBA list.

Answer #3    Answered By: Devrim Yilmaz     Answered On: Feb 16

I was not sure whether Excel shared AutoCorrect entries  with Word, so I
did not step in. But now that I know, there is a very cool template
available at:
word.mvps.org/.../ExportAutocorrect.htm which will
backup all your AutoCorrect Entries and restore them as well.

Didn't find what you were looking for? Find more on Auto-Correct Or get search suggestion and latest updates.