>Is it possible to import an HTML file, in a spreadsheet-like format, directly into a VFP table? It's not in the syntax of VFP7's import or copy to.
>
>I guess I need to manually convert it to XLS, or delim (or whatever) first?
>
>'ppreciate it
>
>Terry
Terry,
I quickly read the whole thread and you've come a long way as I see:) While automaing excel is fun you might not need it. To direct you to another long and winded path < g > I'd say also think of loading the HTM into a DocumentObjectModel and process it w/o putting Excel in between. Of course DOM processing might sound to be easier or harder than automating excel.
PS: Put oExcel.Visible = .t. early in code. It's a myth it would slow down (don't be surprised to see it's faster:). Also it has other advantages like allowing you to step your code, if something goes wrong kill excel application by simply closing excel etc.
Cetin