OK this is where I am now.
I uninstalled VFP and installed it again with SP1
I uninstalled office 2007 and installed office 2003
i try the program again and it comes up with a dialog asking what the field separator is
I click on OK and all is well.
Can that dialog be omitted?
Thanks
Peter
>>Here are the problems.
>>1) I use office 2007
>>
>>2) This line
>>
.OpenDataSource(m.lcSourceDoc)
>>hangs VFP with the infamous Switch to/ Retry error message.
>>Once I release VFP9.sp2 I get to a word dialog which was NOT visible before
>>asking what the field delimiter is. Can that be suppressed? mabe one of those many other parameters of OpenDataSource could eliminate the invisible prompt.
>>(BTW) the same happens when I use a CSV file type
>>
>>Thanks
>>Peter
>
>Tested with 2007. No error and opened as expected.
>Cetin
Peter Cortiel