Spell check problems with forms and macros

N

Nancy

I have been having some major issues with a template form that I have
been trying to add spellcheck to. This thread is a summary of compiled
correspondence so far with John McGhie

Nancy Ristow
Course Reporter

E-mail: (e-mail address removed)
www.capella.edu


Right... No wonder you ran into problems. That is one of the fiercest
macros we offer. It was written for PC Word, and it requires advanced
ability with VBA.

You had some red lines in there: you had not gotten rid of all of the
non-breaking spaces. You have to get the lot :) The easiest way to
do
that is to paste from FireFox (not Safari...) or to paste into Word,
then
Find/Replace non-breaking spaces into spaces :)

However: even after doing that, I discovered that you had left some
bits
out. You can't "delete" anything from that macro: the bit you run
calls the
other bits while its working.



I am looking right now for a
tutorial about learning Macros for Word X, but haven't seen any yet.

Here you go:
http://msdn.microsoft.com/library/default.asp?URL=/library/officedev/odeopg/
deovroffice2000visualbasicprogrammersguide.htm

In two or three years, you'll be good at it :)

Seriously: VBA is a complex and rich programming language, unless you
are
already familiar with programming languages, it may take two or three
years
to get up to the standard needed to take on things as complex as this.


Meanwhile, I think my template is a mess

Yep!

- I can only get so far down
the list trying to fix the red lines before I hit codes that I don't
understand. I am new enough to this macros thing that i don't
understand the tools either.

I went back to the website and pasted their original code in in its
place.
It works as advertised.

I came across another bug, that affects Word 2004 on the Mac (get rid
of
Word X, it's going to give you all manner of problems in this game...)

In Word 2004 (and probably, in Word X...) you cannot run macros if your
document is protected. To get around that, notice that I have put a
"Run
SpellCheck" button on the Standard toolbar. Click that to start the
macro.

To use this, you must create a document FROM the template. The macro
will
work on that. It probably WON'T work properly if you try to start it
from
the template itself, you must use it from a document based upon the
template.

Note that in Mac Word, unless you have the template in your My
Templates
folder, it won't allow macros to run anyway...

'Nuther warning: This macro will work in Word 2003, but it is a
SERIOUSLY
bad idea to try to move this template back and forth from Word X to
Word
2003. You will probably break it.

Instead, make a copy and use that on Word 2003. The difference is that
Word
2003 expresses text in Unicode, Word X uses Mac Roman: completely
different
character set. Word 2003 offers VBA version 6.5, Mac Word uses VBA
version
4.5. Anything written for Mac Word should work in Word 2003, but not
vice-versa. Mac Word is a cut-down version of Microsoft Word: it
doesn't
include the features needed for serious automation development.

Get back to us (on the newsgroup!!) if you have any more trouble :)

Hope this helps
 
N

Nancy

Now I have an interesting new twist to this problem! I put my template
into my template folder in Word, but when I go through the typical open
new document based on my templates route, that template does not show
up as an option - even though it is in the folder! Any suggestions?
Nancy
 
A

AmandaH

For you spell check problem, you need this Marco. It's simple and it is
a direct cut and paste into a module. You can then add the Marco to
your tool bar easy stuff. Check out this site.

http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm

if you have any question about adding to your tool bar or you menu bar
just let me know i can help. You can also make it look just like the
original spell check button so that anyone using the template will
never know that you changed it.

Hope this helps,
~Amanda~
 
N

Nancy

I added that macro with the invaluable help of John McGhie. Now when I
click the spellcheck button, the little spinning clock comes up, macros
screens flash all over my monitor, and I don't know what to do next!
 
A

AmandaH

Nancy said:
I added that macro with the invaluable help of John McGhie. Now when I
click the spellcheck button, the little spinning clock comes up, macros
screens flash all over my monitor, and I don't know what to do next!

Where did John McGhie get the Marco? It sounds to me like there is a
loop the keeps repeating itsself or an error somewhere in the code
 
N

Nancy

I am beginning to wonder if its when I tried to fix the document myself
(before John's help) and didn't know what I was doing, if its an old
macros that opens up the template or something like that.
I got the macros here off an old thread about spellchecking a form. I
also have lines through my drop down menus choices, but doing track
changes doesn't work. How do I get rid of those?
Nancy
 
J

John McGhie

Hi Nancy:

If you're using the template I sent you, there are no old macros in
it.

Can you please zip the template and document you're working on and
send me both.

I did not have time to "test" the solution I sent you. I know it
runs, but i don;t know what it does when has to actually do some work.

Cheers

I am beginning to wonder if its when I tried to fix the document myself
(before John's help) and didn't know what I was doing, if its an old
macros that opens up the template or something like that.
I got the macros here off an old thread about spellchecking a form. I
also have lines through my drop down menus choices, but doing track
changes doesn't work. How do I get rid of those?
Nancy

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 4 1209 1410
 
N

Nancy

I just emailed you my document template. Its the only thing I have
been working on. When I think i have it fixed, I try to open a new
document based on that template, input data into my forms to look to
see if its working and then toss it in the trash. So far my PC buddies
tell me that some editing marks are showing up on their side, but I
can't see them on the Mac version, so I don't know what to do with it.
Nancy
 
J

John McGhie [MVP - Word and Word Macintosh]

The macro we are discussing is the one here:

http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm

I am the webmaster for the site.

I'm on a business trip at the moment and I do not have time to fully examine
the problem. I don't get the errors Nancy is seeing in Word X, but the
macro still doesn't work, in Word 2004.

I will have to completely debug it when I get home. In the meantime, we
should not send any more Mac users to that article: the macro won't work for
them.

Cheers


I just emailed you my document template. Its the only thing I have
been working on. When I think i have it fixed, I try to open a new
document based on that template, input data into my forms to look to
see if its working and then toss it in the trash. So far my PC buddies
tell me that some editing marks are showing up on their side, but I
can't see them on the Mac version, so I don't know what to do with it.
Nancy

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410
 
N

Nancy

Should I wait until this template is repaired to upgrade to Ofice 2004
- or won't it make any difference? I don't want to add any more
headaches to this project. Nancy
 
N

Nancy

Do I need to remove the macros from my form if it will never work? If
so, how do I do that?
Thanks!
 
J

John McGhie [MVP - Word and Word Macintosh]

Yes. Open the VBA editor and "Delete" the Module concerned.

Sorry: I was going to get back to you on this, but it will take some time.

The bug I have run into is that that macro basically unprotects the document
and expects the spelling checker to then be able to check the content of the
filled-in fields.

In Mac Word 2004, it appears that even if you unprotect the document, the
spelling checker still can't access or check the content of the form fields.

There is another way to do it, but it's much more laborious and I need to
find a couple of weekends to put it together for you.

Cheers


Do I need to remove the macros from my form if it will never work? If
so, how do I do that?
Thanks!

Hi Nancy:

Upgrade now.

There is no guarantee that that template will *ever* work on Macintosh Word.

The template relies on particular behaviours of the spelling checker that do
not appear to hold true in Mac Word.

I suspect that the final result will be "You cannot spell check a document
protected for Forms in Mac Word".

Cheers


Should I wait until this template is repaired to upgrade to Ofice 2004
- or won't it make any difference? I don't want to add any more
headaches to this project. Nancy


John McGhie [MVP - Word and Word Macintosh] wrote:
The macro we are discussing is the one here:

http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm

I am the webmaster for the site.

I'm on a business trip at the moment and I do not have time to fully
examine
the problem. I don't get the errors Nancy is seeing in Word X, but the
macro still doesn't work, in Word 2004.

I will have to completely debug it when I get home. In the meantime, we
should not send any more Mac users to that article: the macro won't work
for
them.

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410
 
N

Nancy

Thank you! I appreciate all the help you offer on this newsgroup. If
you do write a new macros in your spare time (ha- sounds like you don't
have any!) please let me know where it will be posted.
Nancy
Yes. Open the VBA editor and "Delete" the Module concerned.

Sorry: I was going to get back to you on this, but it will take some time.

The bug I have run into is that that macro basically unprotects the document
and expects the spelling checker to then be able to check the content of the
filled-in fields.

In Mac Word 2004, it appears that even if you unprotect the document, the
spelling checker still can't access or check the content of the form fields.

There is another way to do it, but it's much more laborious and I need to
find a couple of weekends to put it together for you.

Cheers


Do I need to remove the macros from my form if it will never work? If
so, how do I do that?
Thanks!

Hi Nancy:

Upgrade now.

There is no guarantee that that template will *ever* work on Macintosh Word.

The template relies on particular behaviours of the spelling checker that do
not appear to hold true in Mac Word.

I suspect that the final result will be "You cannot spell check a document
protected for Forms in Mac Word".

Cheers


On 21/7/06 1:16 AM, in article
(e-mail address removed), "Nancy"

Should I wait until this template is repaired to upgrade to Ofice 2004
- or won't it make any difference? I don't want to add any more
headaches to this project. Nancy


John McGhie [MVP - Word and Word Macintosh] wrote:
The macro we are discussing is the one here:

http://word.mvps.org/faqs/macrosvba/SpellcheckProtectDoc.htm

I am the webmaster for the site.

I'm on a business trip at the moment and I do not have time to fully
examine
the problem. I don't get the errors Nancy is seeing in Word X, but the
macro still doesn't work, in Word 2004.

I will have to completely debug it when I get home. In the meantime, we
should not send any more Mac users to that article: the macro won't work
for
them.


--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410

--

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <[email protected]>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 (0) 4 1209 1410
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top