Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Word Errors / May 2007

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
V S Rawat - 26 May 2007 16:07 GMT
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.
Signature

V S Rawat
India

Suzanne S. Barnhill - 26 May 2007 16:24 GMT
You will not reach Dave Rado here. He has not frequented these NGs in many
years. But perhaps someone else can answer your questions.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Hi Rado,
>
[quoted text clipped - 78 lines]
>
> Thanks.
V S Rawat - 26 May 2007 17:24 GMT
> 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.

Signature

Rawat

Suzanne S. Barnhill - 26 May 2007 18:41 GMT
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.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> > You will not reach Dave Rado here. He has not frequented these NGs in
> > many years. But perhaps someone else can answer your questions.
[quoted text clipped - 3 lines]
> 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.
V S Rawat - 30 May 2007 18:12 GMT
> 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.

Signature

Rawat

Klaus Linke - 30 May 2007 22:29 GMT
Hi Rawat,

Thanks for reporting the tip, and thanks to Veronica!

:-) Klaus
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.