Kind Attn; Mr Dave Rado, (MVP), AutoCorrect.dot Macro aborts on finding space while restoring autoco

[V S Rawat]

Hi Rado,

This refers to your article titled "How can I import and export all my
AutoCorrect entries, so they can be transferred to another machine?"
that is at:
http://word.mvps.org/FAQs/Customization/ExportAutocorrect.htm

On the page, you have also given a zip file AutoCorrect.zip that has
macros for backing up the entire list of AutoCorrect entries from Word
to a doc file and also for restoring the backed up AutoCorrect entries
from a doc file overwriting Word's AutoCorrect list.

- I ran that micro and it duly created a doc file on my harddisk.

- I copied the autocorrect table from that doc file to an Excel file.

- I deleted several autocorrect entries from that list in Excel so that
finally I was left with mostly those entries that had come as default
with Word.

- I copied and saved that final list to a doc file.

- I ran the micro again, this time to restore the entries from the doc
file to Word.

And it throws errors:

--start quote
Microsoft Visual Basic
Run-time error "5491":
AutoCorrect cannot replace text which contains a space character.
Please remove the space, or replace it with something else.
--end quote

Well, I have not added any space on my own, I have not even added entry
at all. These entries were very much there is the Word and were working
ever since.

I checked the file from which I was restoring and there indeed are
entries like

againstt he, against the, False
andt he and the False
can't of been can’t have been False
could of been could have been False
could of had could have had False
your a you’re a False
your an you’re an False
your her you’re her False
your here you’re here False
your his you’re his False
your my you’re my False
your the you’re the False
your their you’re their False
you're your you’re your False
you're own your own False

I checked and found that all these entries are very much present in
AutoCoreect in Word and if I type and such phrase wrongly, word is duly
correcting them as above.

I'm on XPSP2 (though Automatic updates is off), Word 2002
(10.2627.2625), Excel 2002 (10.2614.2625), Visual Basic 6.3.9108.

What is the problem? How to insert space into my doc file so that vb
recognizes it correct and updates to Word's Autocorrect?

----------
While we are it at it, some related questions if you entertain:

- Is there any method of resetting Word AutoCorrect list to Default? I
mean so that it removes all the enteries I have added in AutoCorrect,
and keep only those enteries which were shipped by Microsoft?

- If a command won't do the above, can I download the original
Microsoft list of AutoCorrect enteries from somewhere and update into
Word using your Macro? Where from?

If this is not the proper newsgroup for asking this question, please
guide me to where to post this.

Thanks.

 

[Suzanne S. Barnhill]

You will not reach Dave Rado here. He has not frequented these NGs in many
years. But perhaps someone else can answer your questions.

 

[V S Rawat]

You will not reach Dave Rado here. He has not frequented these NGs in
many years. But perhaps someone else can answer your questions.

Thanks Suzzane,

Hope the question is ok for this newsgroup and for referring to Dave.
He might decide to update his macro and reupload that to MVP site.

 

[Suzanne S. Barnhill]

No, we have had no communication with Dave for years. You might, however,
contact the current Webmasters, either of whom would be capable of editing
the macro.

 

[V S Rawat]

No, we have had no communication with Dave for years. You might,
however, contact the current Webmasters, either of whom would be
capable of editing the macro.

One solution has been found.

courtesy Veronica Peek whose site http://www.vpeek.biz/index.html gives
an exhaustive very useful tutorial about autocorrect and even has a
downloadable doc file having a long list of abbreviations.

Her email id is available on her site, and you need to remove one extra
"l" between primus & online from her id there (not
primus"l"online.com.au, but primusonline.com.au). Spam protection I
guess.

She writes:

---start quote

AutoCorrect Backup will accept spaces between words in phrases, but
really spits the dummy if there are any spaces at the end of an entry
in any of the fields. It's a simple program and it can't handle them.
Once you go through and clean out any tail-end spaces in any of the
fields, you shouldn't have any more problems. When you add an entry,
always make sure there are no trailing spaces.

I had to suffer through a similar clean-up but at least it made me
aware of the need to be careful and I have never had any problems
since. By the way, False means unformatted and True means formatted, if
you haven't worked that out already. Also it is important that you
never make any changes to the heading and headers, or you will receive
an error message. AutoCorrect now backs up and restores about 5,000
entries for me in just a few seconds and without any problems, so don't
give up on it just yet.
---end quote

I did that and there were indeed some ending spaces and even some
entire blank lines. I deleted them from the backed up and saved it as a
new file (well, autocorrect has saved the file as read-only).

After that when I ran the Autocorrect backup utility, it restored from
the backup file without any problem.

So, if anybody else faces this problem, please try this solution and
thank Veronica for showing the way.

 

[Klaus Linke]

Hi Rawat,

Thanks for reporting the tip, and thanks to Veronica!

Klaus