MrExcel Publishing
Your One Stop for Excel Tips & Solutions

COPYING AUTO-CORRECT ENTRIES.


Posted by PAUL CROFTS on January 16, 2002 4:10 AM

DOES ANYONE KNOW IF IT'S POSSIBLE TO COPY THE AUTO-CORRECT ENTRIES IN WORD AND EXCEL SO THEY CAN BE TRANSFERRED ONTO ANOTHER COMPUTER.


Posted by Joe Was on January 16, 2002 6:29 AM

Easy, Use the find utility on the windows "Start" button. Use the Find Files box and put *.dic in the box ans search for your list. When you find them note the path copy the file and re-copy it to the same path on the other PC. It should work as if it was done on the PC all along! JSW

Posted by Paul B on January 16, 2002 7:27 AM

This was posted on this site before, works for excel
Sub ListAutocorrect()

Dim correctList As Variant

Dim x As Integer

Application.ScreenUpdating = False

Range("A1").Value = "Replace"

Range("B1").Value = "Replace With"

With Range("A1:B1")

.Font.Bold = True

.HorizontalAlignment = xlCenter

End With

correctList = Application.AutoCorrect.ReplacementList

On Error Resume Next

For x = 1 To UBound(correctList)

Range("A1").Offset(x, 0).Value = correctList(x, 1)

Range("A1").Offset(x, 1).Value = correctList(x, 2)

Next x

Columns("A:B").AutoFit

Application.ScreenUpdating = True

End Sub