>Hello,
>
>I have a comma separated file with single quote delimiters that I am trying to open in Excel 2000 using VFP 6 automation. I can't seem to figure out the parameter or its position to tell excel that the file used the single quote delimeters. Does anyone know what position it is and what value to use?
>Here what I am doing ...
>
>lcFileName = "C:\MyFile.txt"
>loExcel = CreateObject("Excel.Application")
>loExcel.WorkBooks.Open(lcFileName, 2, 1, 1, 2, .F., .F., .F., .T.)
>loExcel.visible = .T.
>
>
>I have tried variations of parameters and values but can't get it right.
>Any help would be greatly appreciated.
>
>Thanks,
>-Isaac
Isaac,
Either use OpenText method where you can specify TextQualifier or as an easier way use CSV format. Excel opens it directly seeing extension.
Cetin