Spellcheck code

[Rod]

Is it possible to spellcheck code?

 

[Douglas J. Steele]

VBA Code? Not that I'm aware of, but then I can't see why you'd want to. I
write magazine articles that include code samples, and the Word spellchecked
always complains about the VBA code: it's not happy with words like
Recordset or QueryDef for instance.

 

[Rod]

VBA code, yes.

Your code is always going to contain actual phrases (of the "Press any key
to continue" variety at least). I figured it shouldn't be too difficult to
write an add-in that ignored existent keywords and recognised variables where
they are defined by Dim statements (assuming Option Explicit). What remains
after keywords and declared variables could be checked for spelling mistakes.

Anybody know of such an add-in?

 

[Douglas J. Steele]

Take a look at Total Access Speller, from FMS
http://www.fmsinc.com/products/speller/

Afraid I don't know whether it can do exactly what you're looking for, but
there is a free trial version.

 

[.]

dans l'article (e-mail address removed), Rod à
(e-mail address removed) a écrit le 23/01/08 11:02 :