Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
I'm doing some work with games. We generate about 2,100 WORDS from a grid of
3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correctword
Unless your rules involve some other connection than horizontal,
vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31*pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T * * * O * * * I * * * T * * * S * * * N * * * Y L * * * R * * * M * * * B * * * O * * * R * * * T C * * * A * * * N * * * K * * * E * * * A * * * N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct
The rules are simply one letter at a time, left to right. And it does spell
LANTERN. Thanks, though. "Peter T. Daniels" wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct
Assuming one word per line and the required proofing language applied, you
can highlight the correctly spelled words (according to the Word dictionary) with the following macro For i = ActiveDocument.Paragraphs.Count To 1 Step -1 If ActiveDocument.Paragraphs(i).Range.SpellingErrors. Count = 0 Then ActiveDocument.Paragraphs(i).Range.HighlightColorI ndex = wdRed End If Next i or delete the misspelled words with For i = ActiveDocument.Paragraphs.Count To 1 Step -1 If ActiveDocument.Paragraphs(i).Range.SpellingErrors. Count 0 Then ActiveDocument.Paragraphs(i).Range.Delete End If Next i http://www.gmayor.com/installing_macro.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SoNouveau wrote: The rules are simply one letter at a time, left to right. And it does spell LANTERN. Thanks, though. "Peter T. Daniels" wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct
Ah, one from column A, one from column B, etc. I couldn't imagine!
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "SoNouveau" wrote in message ... The rules are simply one letter at a time, left to right. And it does spell LANTERN. Thanks, though. "Peter T. Daniels" wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct
So (if only 7-letter words are allowed) this grid also yields CANKERY.
Puzzle magazines have a puzzle in which you reconstruct a quote from a grid like that (each column contains a bunch of letters over a bunch of blanks that the letters are to be dropped into), but they never have as few as three lines -- solving such a puzzle would be trivial. Unless this is an exercise in an elementary English textbook, surely the Yahtzee or Boggle rules are needed to make the game interesting. On Sep 20, 8:09*am, "Suzanne S. Barnhill" wrote: Ah, one from column A, one from column B, etc. I couldn't imagine! -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USAhttp://word.mvps.org "SoNouveau" wrote in message ... The rules are simply one letter at a time, left to right. And it does spell LANTERN. Thanks, though. "Peter T. Daniels" wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T * * * O * * * I * * * T * * * S * * * N * * * Y L * * * R * * * M * * * B * * * O * * * R * * * T C * * * A * * * N * * * K * * * E * * * A * * * N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL- |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
Peter,
Here you have violated goals and objective statement 6. 6. Bridle your arrogance. Instead of simply asking the OP what the rules are for the game, you assumed that you are infallible and the OP is wrong. You open your mouth to attempt to prove your superiority and dine on crow again. Peter T. Daniels wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correctword
Graham showed you how to highlight words that were not flagged as
spelling errors by Word's dictionary, This piece of code will flag spelling errors with yellow hightlight and move them to a list at the end of the document. Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors oCol.Add oSp.Text oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors oSp.HighlightColorIndex = wdYellow Next oSp End Sub I realize that you didn't ask Peter T. Daniels for his opinion on your game. Cankery is in fact not listed in the Word dicitionary or it's dictionary reference. However it is defined in other dicitonaries. If his fault finding or suggestions have helped you then well and good. If is arrogance and fault finding has offended you then all all I can do is apologize on his behalf. Good luck. On Sep 19, 5:31*pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T * * * O * * * I * * * T * * * S * * * N * * * Y L * * * R * * * M * * * B * * * O * * * R * * * T C * * * A * * * N * * * K * * * E * * * A * * * N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correctword
OP does not want to highlight the nearly 2100 non-words. OP wants to
highlight the few correctly spelled words. On Sep 20, 9:42*am, Greg Maxey wrote: Graham showed you how to highlight words that were not flagged as spelling errors by Word's dictionary, *This piece of code will flag spelling errors with yellow hightlight and move them to a list at the end of the document. Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors * oCol.Add oSp.Text * oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count * ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors * oSp.HighlightColorIndex = wdYellow Next oSp End Sub I realize that you didn't ask Peter T. Daniels for his opinion on your game. *Cankery is in fact not listed in the Word dicitionary or it's dictionary reference. *However it is defined in other dicitonaries. If his fault finding or suggestions have helped you then well and good. If is arrogance and fault finding has offended you then all all I can do is apologize on his behalf. Good luck. On Sep 19, 5:31*pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T * * * O * * * I * * * T * * * S * * * N * * * Y L * * * R * * * M * * * B * * * O * * * R * * * T C * * * A * * * N * * * K * * * E * * * A * * * N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL- |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
In the matrix the OP presented, there are no correct words; the whole thing
is incorrect (except that, given the spaces between letters, nothing will be marked as incorrect because it's all single letters). In order to actually find correct words, you have to sort the wheat from the chaff. A macro to do this would have to be very sophisticated. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Greg Maxey" wrote in message ... Graham showed you how to highlight words that were not flagged as spelling errors by Word's dictionary, This piece of code will flag spelling errors with yellow hightlight and move them to a list at the end of the document. Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors oCol.Add oSp.Text oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors oSp.HighlightColorIndex = wdYellow Next oSp End Sub I realize that you didn't ask Peter T. Daniels for his opinion on your game. Cankery is in fact not listed in the Word dicitionary or it's dictionary reference. However it is defined in other dicitonaries. If his fault finding or suggestions have helped you then well and good. If is arrogance and fault finding has offended you then all all I can do is apologize on his behalf. Good luck. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
Peter T. Daniels wrote:
OP does not want to highlight the nearly 2100 non-words. OP wants to highlight the few correctly spelled words. On Sep 20, 9:42 am, Greg Maxey wrote: Graham showed you how to highlight words that were not flagged as spelling errors by Word's dictionary, This piece of code will flag spelling errors with yellow hightlight and move them to a list at the end of the document. Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors oCol.Add oSp.Text oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors oSp.HighlightColorIndex = wdYellow Next oSp End Sub I realize that you didn't ask Peter T. Daniels for his opinion on your game. Cankery is in fact not listed in the Word dicitionary or it's dictionary reference. However it is defined in other dicitonaries. If his fault finding or suggestions have helped you then well and good. If is arrogance and fault finding has offended you then all all I can do is apologize on his behalf. Good luck. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL- Peter, Where is your muzzle? Please wear it. Why do you post: "OP does not want to highlight the nearly 2100 non-words. OP wants to highlight the few correctly spelled words." After the OP posts: "Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words." Read the question and read that the OP says what I "really" want. I already conceded that Graham's process provides a list of highlighted correctly spelled words. The macro I provided highlights the mispelled words in yellow and moves them to a list at the end of the document. You may be correct, but until the OP comes back and asks for something else, I will stick to trying to answer the question asked. OP, I didn't notice that your words were in a column. If as Graham stated the list of words consists of one word per line you can modify my earlier code as follows: Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors oCol.Add oSp.Text oSp.MoveEnd wdCharacter, 1 'Added this line to remove empty paragraph oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors oSp.HighlightColorIndex = wdYellow Next oSp End Sub -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR |
#12
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
Ms. Barnhill,
I was not proposing a macro to find correct or incorrect spelling in the matrix. The OP indicated that EXCEL is used to sort the wheat from the chaff and then the list of letter combinations is pasted into Word for spell checking. The macro Graham posted probably meets the OP's need. The macro I posted will also hopefully meet the OP's need. Other than as another display of his unbridled arrogance or to increase an already bloated post count I don't really know why Peter T. Daniels posted. I do wish he would stop. Suzanne S. Barnhill wrote: In the matrix the OP presented, there are no correct words; the whole thing is incorrect (except that, given the spaces between letters, nothing will be marked as incorrect because it's all single letters). In order to actually find correct words, you have to sort the wheat from the chaff. A macro to do this would have to be very sophisticated. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR |
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correctword
Once again, Greg shows that he has great difficulty reading for
content. What OP "really wants" is a way to quickly pick out the tiny number of real words from a list of 2100 items (ideally there is only one real word in the entire list), which is _exactly_ what Graham's routine provides. On Sep 20, 10:25*am, "Suzanne S. Barnhill" wrote: In the matrix the OP presented, there are no correct words; the whole thing is incorrect (except that, given the spaces between letters, nothing will be marked as incorrect because it's all single letters). In order to actually find correct words, you have to sort the wheat from the chaff. A macro to do this would have to be very sophisticated. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USAhttp://word.mvps.org "Greg Maxey" wrote in message ... Graham showed you how to highlight words that were not flagged as spelling errors by Word's dictionary, *This piece of code will flag spelling errors with yellow hightlight and move them to a list at the end of the document. Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors * oCol.Add oSp.Text * oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count * ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors * oSp.HighlightColorIndex = wdYellow Next oSp End Sub I realize that you didn't ask Peter T. Daniels for his opinion on your game. *Cankery is in fact not listed in the Word dicitionary or it's dictionary reference. *However it is defined in other dicitonaries. If his fault finding or suggestions have helped you then well and good. If is arrogance and fault finding has offended you then all all I can do is apologize on his behalf. Good luck. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL- Hide quoted text - - Show quoted text - |
#14
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
Yes, I see now that the macro is designed to operate on results rather than
the matrix. I guess I hadn't read enough of the original post to realize that the OP had already extracted all the possible words. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Greg Maxey" wrote in message ... Ms. Barnhill, I was not proposing a macro to find correct or incorrect spelling in the matrix. The OP indicated that EXCEL is used to sort the wheat from the chaff and then the list of letter combinations is pasted into Word for spell checking. The macro Graham posted probably meets the OP's need. The macro I posted will also hopefully meet the OP's need. Other than as another display of his unbridled arrogance or to increase an already bloated post count I don't really know why Peter T. Daniels posted. I do wish he would stop. Suzanne S. Barnhill wrote: In the matrix the OP presented, there are no correct words; the whole thing is incorrect (except that, given the spaces between letters, nothing will be marked as incorrect because it's all single letters). In order to actually find correct words, you have to sort the wheat from the chaff. A macro to do this would have to be very sophisticated. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR |
#15
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
Once again, Peter shows that he has great difficulty reading at all. Worse
he shows again his skill at poking his nose into posts that he should simply leave alone. Greg concedes in his opening post that Graham's proposed macro works. He concedes that same thing again in his follow-up post to Ms. Barnhill. Greg has also shown a alternative solution to the OP's requirement that just so happened to do exactly what the OP had asked for. His post was not a challenge to Graham's. It simply shows a way to highlight spelling errors with something other than Word's built-in squiggly line. While Greg's posts might be useful to the OP or others looking for an alternate method of highlighting spelling errors (e.g., Dr. Kettle), Peter's have simply been arrogant and argumentative. Peter T. Daniels wrote: Once again, Greg shows that he has great difficulty reading for content. What OP "really wants" is a way to quickly pick out the tiny number of real words from a list of 2100 items (ideally there is only one real word in the entire list), which is _exactly_ what Graham's routine provides. On Sep 20, 10:25 am, "Suzanne S. Barnhill" wrote: In the matrix the OP presented, there are no correct words; the whole thing is incorrect (except that, given the spaces between letters, nothing will be marked as incorrect because it's all single letters). In order to actually find correct words, you have to sort the wheat from the chaff. A macro to do this would have to be very sophisticated. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USAhttp://word.mvps.org "Greg Maxey" wrote in message ... Graham showed you how to highlight words that were not flagged as spelling errors by Word's dictionary, This piece of code will flag spelling errors with yellow hightlight and move them to a list at the end of the document. Sub SuperFlagErrors() Dim oSp As Word.Range Dim oCol As New Collection Dim i As Long For Each oSp In ActiveDocument.Range.SpellingErrors oCol.Add oSp.Text oSp.Delete Next oSp ActiveDocument.Range.InsertAfter vbCr For i = 1 To oCol.Count ActiveDocument.Range.InsertAfter oCol(i) & vbCr Next i For Each oSp In ActiveDocument.Range.SpellingErrors oSp.HighlightColorIndex = wdYellow Next oSp End Sub I realize that you didn't ask Peter T. Daniels for his opinion on your game. Cankery is in fact not listed in the Word dicitionary or it's dictionary reference. However it is defined in other dicitonaries. If his fault finding or suggestions have helped you then well and good. If is arrogance and fault finding has offended you then all all I can do is apologize on his behalf. Good luck. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL- Hide quoted text - - Show quoted text - -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR |
#16
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct word
No harm, no foul. People often make mistakes.
It is those with a belief in their own infallibility, who when obviously wrong continue in their arguments, that are so irritating. Suzanne S. Barnhill wrote: Yes, I see now that the macro is designed to operate on results rather than the matrix. I guess I hadn't read enough of the original post to realize that the OP had already extracted all the possible words. "Greg Maxey" wrote in message ... Ms. Barnhill, I was not proposing a macro to find correct or incorrect spelling in the matrix. The OP indicated that EXCEL is used to sort the wheat from the chaff and then the list of letter combinations is pasted into Word for spell checking. The macro Graham posted probably meets the OP's need. The macro I posted will also hopefully meet the OP's need. Other than as another display of his unbridled arrogance or to increase an already bloated post count I don't really know why Peter T. Daniels posted. I do wish he would stop. Suzanne S. Barnhill wrote: In the matrix the OP presented, there are no correct words; the whole thing is incorrect (except that, given the spaces between letters, nothing will be marked as incorrect because it's all single letters). In order to actually find correct words, you have to sort the wheat from the chaff. A macro to do this would have to be very sophisticated. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR -- Greg Maxey See my web site http://gregmaxey.mvps.org for an eclectic collection of Word Tips. "It is not the critic who counts, not the man who points out how the strong man stumbles, or where the doer of deeds could have done them better. The credit belongs to the man in the arena, whose face is marred by dust and sweat and blood, who strives valiantly...who knows the great enthusiasms, the great devotions, who spends himself in a worthy cause, who at the best knows in the end the triumph of high achievement, and who at the worst, if he fails, at least fails while daring greatly, so that his place shall never be with those cold and timid souls who have never known neither victory nor defeat." - TR |
#17
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct
solving such a puzzle would be trivial.
Would be trivial for whom? Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium at http://www.ralphwatson.tv Peter T. Daniels wrote: So (if only 7-letter words are allowed) this grid also yields CANKERY. Puzzle magazines have a puzzle in which you reconstruct a quote from a grid like that (each column contains a bunch of letters over a bunch of blanks that the letters are to be dropped into), but they never have as few as three lines -- solving such a puzzle would be trivial. Unless this is an exercise in an elementary English textbook, surely the Yahtzee or Boggle rules are needed to make the game interesting. On Sep 20, 8:09 am, "Suzanne S. Barnhill" wrote: Ah, one from column A, one from column B, etc. I couldn't imagine! -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USAhttp://word.mvps.org "SoNouveau" wrote in message ... The rules are simply one letter at a time, left to right. And it does spell LANTERN. Thanks, though. "Peter T. Daniels" wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T O I T S N Y L R M B O R T C A N K E A N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL- |
#18
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Want to highlight misspelled words, OR ... easily see correct
On Sep 20, 3:11*pm, Peter Jamieson
wrote: * solving such a puzzle would be trivial. Would be trivial for whom? The typical puzzle / word game -solver. Peter Jamieson http://tips.pjmsn.me.uk Visit Londinium athttp://www.ralphwatson.tv Peter T. Daniels wrote: So (if only 7-letter words are allowed) this grid also yields CANKERY. Puzzle magazines have a puzzle in which you reconstruct a quote from a grid like that (each column contains a bunch of letters over a bunch of blanks that the letters are to be dropped into), but they never have as few as three lines -- solving such a puzzle would be trivial. Unless this is an exercise in an elementary English textbook, surely the Yahtzee or Boggle rules are needed to make the game interesting. On Sep 20, 8:09 am, "Suzanne S. Barnhill" wrote: Ah, one from column A, one from column B, etc. I couldn't imagine! -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USAhttp://word.mvps.org "SoNouveau" wrote in message ... The rules are simply one letter at a time, left to right. And it does spell LANTERN. Thanks, though. "Peter T. Daniels" wrote: Unless your rules involve some other connection than horizontal, vertical, and diagonal, that grid doesn't give LANTERN. It does, though, give CANKER. And the name LAMBERT. On Sep 19, 5:31 pm, SoNouveau wrote: I'm doing some work with games. We generate about 2,100 WORDS from a grid of 3 letters by 7 letters: T * * * O * * * I * * * T * * * S * * * N * * * Y L * * * R * * * M * * * B * * * O * * * R * * * T C * * * A * * * N * * * K * * * E * * * A * * * N Only ONE word (!) is supposed to be correctly spelled when all is said and done (in this case, LANTERN). So, I create a list of all the various combinations of letters in Excel, by concatenation. Then I cut and paste the 2,100 words into Word--and it does spell checks for me. BUT, it's VERY hard to pick out the 1, 2, 3, or 4 CORRECTLY spelled words as I scan all 2,000 words. (And I do this again and again.) I want to make sure I don't miss any!!!! So, what I really want is to highlight in yellow, say, all the incorrect words or ... SOMEHOW, be able to sort/format/or whatever so that correctly spelled words are easy to pick out from these long columns of words. Is that clear AT ALL!?!? LOL-- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Visually impaired: Highlight misspelled words... | New Users | |||
correct a misspelled word in the spellchecker | Microsoft Word Help | |||
Word doesn't recognize some misspelled words. | Microsoft Word Help | |||
How do I correct a misspelled word in a smart tag? | Microsoft Word Help |