Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Phil Sanchez   on Feb 16 In MS Office Category.

  
Question Answered By: Feodora Bonkob   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

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

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


Tagged: