>John,
>
>Thanks for your quick reply.
>
>Is there a way to save the changed Excel sheet as a new dbf file. I forgot that part of the problem in my question.
>
Gee, if you had VFP7 you could just instance the object and see all the pems.< G >
Since you don't, you can create a macro that does what you need in Excel, then edit the macro to steal the code. For your immediate problem you simply issue
ox.Range("A1").Select && or wherever your first row (headers) starts
ox.ActiveWorkbook.SaveAs('c:\mydbfdbf',8)
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright