The great Homophones Problem.



Hello NG friends,

I am trying to include in an existing macro a routine to offer help to
learners writing English. Their finished text is analysed and a table
of various errors displayed below in the document. Homophones are, of
course, not picked up by SpellCheckers, but the teacher can mark them
(in this case with a blue background) and the macro makes the marked
words (=BluWords) appear in Column 1 of the Table. I intend now to
prepare a .txt file in which each line contains firstly a common
BluWord followed by three (or fewer) suggested substitutions for it, to
be displayed in Columns 2, 3 and 4 of the Table.

I feel able to code _some_ of this, but I know nothing about file
access. For example, what separators would I use in constructing the
Homophones.txt file? Would a simple space suffice? How do I persuade
the routine (a) to open and close the text file, (b) to search the
first word of each line of the .txt file for a match (non case
specific) to the BluWord being considered in that loop, (c) to read off
the remaining words in that line of the file and display them (as
above) in the Table? Finally, would the inserted words take on the
formatting of the Word Table automatically?

I acknowledge with gratitude help received from this NG so far.
Many thanks.
Robert.

.



Relevant Pages

  • Re: Routine Interfering with Clipboard
    ... Otherwise use the temporary array, eg open one wb, assign the values ... file in created Inst2 that from its Open event starts a new routine called ... The macro therefore takes 25mins to run. ... instance of Excel and then open a second hidden instance to do all the ...
    (microsoft.public.excel.programming)
  • Re: AutoOpen Macro Not Showing Toolbar
    ... > in his AutoClose macro. ... routine displayed the toolbar. ... I created AutoOpen and AutoClose ... Then it suddenly occurred to me that I had made AutoOpen a private routine. ...
    (microsoft.public.word.vba.general)
  • Re: Macro Error Handling
    ... for example, if you use the worksheet function VLOOKUP in VBA, it raises an error if there's no match. ... if there's no match, VLOOKUP raises an error, which resumes at the next line, switching off the error trap condition and a zero is safely returned to the calling routine ... Before each "cells.find" I have inserted a statement "On Error goto ... If I encounter another error condition the macro does not take the branch to ...
    (microsoft.public.excel.programming)
  • Re: Save - Yes / No / Cancel
    ... Peltier Technical Services ... I have found some vba that may " Force users to enable ... hidden except one that says about your macro status. ... other sheets are visable using the very-visable routine. ...
    (microsoft.public.excel.misc)