Spell Checking with VBA Code Bug in Word 2003

Roy Gracious · External Since: Jun 09, 2005 Posts: 6

Hi -
My post to the google group regarding a problem I have didn't seem to
go through so I'm trying here.

The problem I am having is the same as the one listed under the topic "Spell
Checking with VBA Code Bug in Word 2003" in google groups. Basically

Does anyone know if/when there is going to be a fix from Microsoft for this
problem?

PS: I found a partial workaround (below) that seems to work for me in most
scenarios. Scenario it didn't work is if there is static text and a form
field (bookmark) in a table cell.

In Public Sub SpellCheck()...

oDoc.SpellingChecked = True

Thanks,

Cindy M -WordMVP- · External Since: Jun 21, 2004 Posts: 1830

Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,

> The problem I am having is the same as the one listed under the topic "Spell
> Checking with VBA Code Bug in Word 2003" in google groups.
>
Link to that message thread?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail Smile

Roy Gracious · External Since: Jun 09, 2005 Posts: 6

Yes, please. I couldn't find and link it to that message thread.

"Cindy M -WordMVP-" wrote:

> Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,
>
> > The problem I am having is the same as the one listed under the topic "Spell
> > Checking with VBA Code Bug in Word 2003" in google groups.
> >
> Link to that message thread?
>
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
> http://www.word.mvps.org
>
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail Smile

>
>

Cindy M -WordMVP- · External Since: Jun 21, 2004 Posts: 1830

Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,

> Yes, please. I couldn't find and link it to that message thread.
>
No, you mention the topic. I'm asking you for a link so that I can see the
discussion. Without that information, it makes no sense to start a discussion...

> > > The problem I am having is the same as the one listed under the topic "Spell
> > > Checking with VBA Code Bug in Word 2003" in google groups.
> > >
> > Link to that message thread?
>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail Smile

garfield-n-odie · External Since: Jun 27, 2004 Posts: 2383

Roy Gracious is talking about
http://groups-beta.google.com/group/microsoft.public.word.spelling.gra...r/brows
..

Cindy M -WordMVP- wrote:
> Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,
>
>
>>Yes, please. I couldn't find and link it to that message thread.
>>
>
> No, you mention the topic. I'm asking you for a link so that I can see the
> discussion. Without that information, it makes no sense to start a discussion...
>
>
>>>>The problem I am having is the same as the one listed under the topic "Spell
>>>>Checking with VBA Code Bug in Word 2003" in google groups.
>>>>
>>>
>>>Link to that message thread?
>>
>
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
> http://www.word.mvps.org
>
> This reply is posted in the Newsgroup; please post any follow question or reply in
> the newsgroup and not by e-mail Smile

>

Roy Gracious · External Since: Jun 09, 2005 Posts: 6

Thanks. This is the thread I was talking about.

"garfield-n-odie" wrote:

> Roy Gracious is talking about
> http://groups-beta.google.com/group/microsoft.public.word.spelling.gra...r/brows
> ..
>
> Cindy M -WordMVP- wrote:
> > Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,
> >
> >
> >>Yes, please. I couldn't find and link it to that message thread.
> >>
> >
> > No, you mention the topic. I'm asking you for a link so that I can see the
> > discussion. Without that information, it makes no sense to start a discussion...
> >
> >
> >>>>The problem I am having is the same as the one listed under the topic "Spell
> >>>>Checking with VBA Code Bug in Word 2003" in google groups.
> >>>>
> >>>
> >>>Link to that message thread?
> >>
> >
> > Cindy Meister
> > INTER-Solutions, Switzerland
> > http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
> > http://www.word.mvps.org
> >
> > This reply is posted in the Newsgroup; please post any follow question or reply in
> > the newsgroup and not by e-mail Smile

> >
>
>

Cindy M -WordMVP- · External Since: Jun 21, 2004 Posts: 1830

Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,

> The problem I am having is the same as the one listed under the topic "Spell
> Checking with VBA Code Bug in Word 2003" in google groups. Basically
>
> Does anyone know if/when there is going to be a fix from Microsoft for this
> problem?
>
I've never seen the problem, and I have my doubts whether this has even been
reported to MS. With which KIND of protection are you working? Can you give me
exact steps to reproduce it?

"We think we may have found a bug with how the spell
checker works via VBA in Word 2003.

Large document with mostly protected sections.

Invoke Spell Checker on a Range that is unprotected and
the Spell Checker continues to Spell check the entire
document even protected sections. Seems that
Range.CheckSpelling is not stopping at the end of the
range. The range is simply just a section. "

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail Smile

Roy Gracious · External Since: Jun 09, 2005 Posts: 6

Hi Cindy -
I don't think the protection type matters. The steps to
re-create are

1) Download the zip file that contains the sample spellcheck macro from
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
the macro in the zip file is slightly older (and different) from the one in
the web page, but I have tried both versions and I have had the same result,
so the one in the zip file should be fine.
2) Run Macro by going to Visual Basic Editor (Alt + F11) and hitting the run
button
Notice that the spellcheck goes into the static text and tries to
correct it even though document is protected. Also, notice that the
spellcheck goes into a loop, i.e. it will spellcheck twice.

The partial workaround I found was that
In Public Sub SpellCheck()...

oDoc.SpellingChecked = True

This seemed to work in most scenarios except in some documents if there is
static text and a form field in the same table cell, spellchecker checks the
static text.

Thanks,
Roy.

"Cindy M -WordMVP-" wrote:

> Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,
>
> > The problem I am having is the same as the one listed under the topic "Spell
> > Checking with VBA Code Bug in Word 2003" in google groups. Basically
> >
> > Does anyone know if/when there is going to be a fix from Microsoft for this
> > problem?
> >
> I've never seen the problem, and I have my doubts whether this has even been
> reported to MS. With which KIND of protection are you working? Can you give me
> exact steps to reproduce it?
>
> "We think we may have found a bug with how the spell
> checker works via VBA in Word 2003.
>
> Large document with mostly protected sections.
>
> Invoke Spell Checker on a Range that is unprotected and
> the Spell Checker continues to Spell check the entire
> document even protected sections. Seems that
> Range.CheckSpelling is not stopping at the end of the
> range. The range is simply just a section. "
>
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
> http://www.word.mvps.org
>
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail Smile

>
>

Cindy M -WordMVP- · External Since: Jun 21, 2004 Posts: 1830

Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,

Ah. Well this macro has nothing to do with any possible bug in Word 2003. The
macro removes the document protection in order to run spell-check, so yes, it
will check the text around the form fields, as well as the form fields.

If you don't want what you call "static text" to be checked, then you need to
either run spellcheck before protecting and setting these words to "ignore" or
(preferably) format them to be ignored (Tools/Language/Set language, activate
the checkbox to not check spelling and grammar).

I'm not familiar with the macro in detail, so I have no idea why it might be
checking something twice. I'd say you need to take that up with the person who
wrote the macro, but he's not around any more...

> 1) Download the zip file that contains the sample spellcheck macro from
> http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
> the macro in the zip file is slightly older (and different) from the one in
> the web page, but I have tried both versions and I have had the same result,
> so the one in the zip file should be fine.
> 2) Run Macro by going to Visual Basic Editor (Alt + F11) and hitting the run
> button
> Notice that the spellcheck goes into the static text and tries to
> correct it even though document is protected. Also, notice that the
> spellcheck goes into a loop, i.e. it will spellcheck twice.
>
> The partial workaround I found was that
> In Public Sub SpellCheck()...
>
> oDoc.SpellingChecked = True
>
> This seemed to work in most scenarios except in some documents if there is
> static text and a form field in the same table cell, spellchecker checks the
> static text.
>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail Smile

Roy Gracious · External Since: Jun 09, 2005 Posts: 6

Hi Cindy -
The macro does perform spellcheck on only form fields and
not on static text (no need to set these words to "ignore" or (preferably)
format them to be ignored).

Anyway, the problem that I was noticing was happening on only one of the
templates that I was working on. When I created a brand new template, my
partial fix took care of spellchecking static text problem.

CONCLUSION:
If anyone is using this macro for spellcheck (for Word 2003), do the
following to avoid spell-checking static text.

In Public Sub SpellCheck()...

oDoc.SpellingChecked = True

Thanks,
Roy.

"Cindy M -WordMVP-" wrote:

> Hi =?Utf-8?B?Um95IEdyYWNpb3Vz?=,
>
> Ah. Well this macro has nothing to do with any possible bug in Word 2003. The
> macro removes the document protection in order to run spell-check, so yes, it
> will check the text around the form fields, as well as the form fields.
>
> If you don't want what you call "static text" to be checked, then you need to
> either run spellcheck before protecting and setting these words to "ignore" or
> (preferably) format them to be ignored (Tools/Language/Set language, activate
> the checkbox to not check spelling and grammar).
>
> I'm not familiar with the macro in detail, so I have no idea why it might be
> checking something twice. I'd say you need to take that up with the person who
> wrote the macro, but he's not around any more...
>
> > 1) Download the zip file that contains the sample spellcheck macro from
> > http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
> > the macro in the zip file is slightly older (and different) from the one in
> > the web page, but I have tried both versions and I have had the same result,
> > so the one in the zip file should be fine.
> > 2) Run Macro by going to Visual Basic Editor (Alt + F11) and hitting the run
> > button
> > Notice that the spellcheck goes into the static text and tries to
> > correct it even though document is protected. Also, notice that the
> > spellcheck goes into a loop, i.e. it will spellcheck twice.
> >
> > The partial workaround I found was that
> > In Public Sub SpellCheck()...
> >
> > oDoc.SpellingChecked = True
> >
> > This seemed to work in most scenarios except in some documents if there is
> > static text and a form field in the same table cell, spellchecker checks the
> > static text.
> >
>
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
> http://www.word.mvps.org
>
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail Smile

>
>