Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to move AutoCorrect entries between computers in Word 2007
i want backup my autocorrect ,i use office 2007 how i can do that
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to move AutoCorrect entries between computers in Word 2007
You can use a blank sheet to list the replacement list, save the workbook
and then use it to restore : The following macro saves the data : Sub Save() Dim i As Long With Application.AutoCorrect For i = 1 To UBound(.ReplacementList) Cells(i, 1) = .ReplacementList(i)(1) Cells(i, 2) = .ReplacementList(i)(2) Next i End With End Sub and the following one to restore : Sub Restore() Dim i As Long With Application.AutoCorrect For Each c In Range([A1], [A65536].End(xlUp)) i = 1 + i .ReplacementList(i)(1) = Cells(i, 1) .ReplacementList(i)(2) = Cells(i, 2) Next End With End Sub Regards. Daniel "emad" <emad @discussions.microsoft.com a écrit dans le message de news: ... i want backup my autocorrect ,i use office 2007 how i can do that |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Move-Drag and Drop Fails in Office 2007 Excel & Word | Excel Discussion (Misc queries) | |||
How do I use the same Autocorrect options in word and excel | Excel Discussion (Misc queries) | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
WHERE IS THE AUTOCORRECT OPTION IN EXCEL 2007? | Excel Discussion (Misc queries) | |||
How can I move multiple linked workbooks between computers | Excel Discussion (Misc queries) |