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