I don't have an immediate answer to your query regarding "OpenText". I will say that the VFP->VBA code could be tested from the command window (VFP 7 is great for this stuff), thus reducing the necessity of editing a PRG or CLASS. There is a book, Using Visual FoxPro 6, (Bazian) that is a great resource for these kinds of things. Perhaps a little later, when I catch up, I can play with it.
which left me wondering if there was a way to convert an existing word doc with its table into vfp automation code.
You can open an existing word document, and use VFP/VBF to ask questions about its contents and format, just a reliably as you can assign them!




>Terry,
>Thanks very much again. I have used the macro recorder many times. Recently,however, I ran into this form
>
>http://tram.east.asu.edu/forms/downloads/epa/pc/epa-424.doc
>
>which left me wondering if there was a way to convert an existing word doc with its table into vfp automation code.
>
>By the way, would you know how to covert this bit of VB code -- taken from a macro recording of opening a text file in Excel -- into VFP code?
>
>Workbooks.OpenText Filename:="C:\d\tax\200210.txt", Origin:=xlWindows, _
>StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(14 _
>, 1), Array(42, 1), Array(67, 1), Array(70, 1), Array(83, 1))
>
>The above code seems to duplicate the act of appending in a text file into a vfp table, then using the replace command to sutff a series of fields, based on the knowledge the text file stores data in fixed width columns.
>
>Steve
>
>
>