Auto correct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am adding to the auto correct list and would like to have the
list saved to file and/or printed.
Can that be done/how?

Regards,

Geb
 
Are you using Microsoft Access? This sounds more like a Microsoft Word
question.

I'm pretty sure that list *IS* saved as a file that you can open with
WordPad or similar. I have stumbled across it before.
 
I am using Access and the question is referring to the auto correct feature
that can be found in several locations, one of them being from the Tools>
Options <General tab> and from the <Spelling tab>.
The question is if the list create can be printed or saved as a file.

Regards,

Geb
 
Looks to me like the file name for the auto-correct spelling items is right
there on your screen. Mine is named "custom.dic". I'd probably go find
that file.

The general tab includes an option to "Log name AutoCorrect chnages". When
I use the "what's this" feature for that checkbox, it tells me that the
changes will be logged in a table called AutoCorrect.log. I'd think you
could open and print that table, build a report off of it, export it to a
file, etc.
 
GEB said:
I am using Access and the question is referring to the auto correct feature
that can be found in several locations, one of them being from the Tools>
Options <General tab> and from the <Spelling tab>.
The question is if the list create can be printed or saved as a file.

Regards,

Geb

:
Click to expand...
If you're using the default custom.dic to store your list a search for that
file should get you a list that can be opened in wordpad or notepad.

gls858
 
The 'custom.dic' contains words that have been added to the
user dictionary that were detected as mispelled.
The custom auto correct entries do not appear there.

I have the log box checked and will continue to locate where the informations
is saved.
 
GEB

The autocorrect feature you are referring to is a feature "shared" among all
your Office applications.

To print the contents of the Autocorrect, please follow the instructions
found here;

http://support.microsoft.com/default.aspx?scid=kb;en-us;212518

It will give you all the necessary steps to create a Word document out of
your autocorrect entries (it doesn't matter whether you create them in Word,
Excel, PowerPoint or Access).

I am unaware of a method of printing the entries from Access, but I have
done it from Word.

HTH

Debra
 
Hi Geb,

The only way I know to get at it is via Word's AutoCorrect object.
Something like this:

Sub ListAutoCorrectEntries(FileSpec As String)
Dim oWord As Object 'Word.Application
Dim lngFN As Long
Dim j As Long

Set oWord = CreateObject("Word.Application")
lngFN = FreeFile()
Open FileSpec For Output As #lngFN

With oWord.AutoCorrect.Entries
For j = 1 To .Count
With .Item(j)
If Not .RichText Then
'Rich text entries are for Word only
Print #lngFN, j & vbtab & .Name & vbTab & .Value
End If
End With
Next
End With

Close #lngFN
oWord.Quit
End Sub
 
Back
Top