Probably could be omitted specifying the second parameter wdOpenFormat but the question is:
Why you get the dialog and I don't? (my settings are all set to EN-US).
Cetin
>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