Open.text macro fn syntax

[cuckoonuck]

I have a FoxPro application which uses DDE to open a text file in Excel
and save it as a spreadsheet. I can open the text file with the
OPEN.TXT macro function but I need to specify that the columns be
treated as "Text" not "General" (the default). There is a field_info
parameter (an array of two-element arrays) for the OPEN.TEXT macro
function, but I do not know the proper syntax for it. Could someone
please give me an example of the OPEN.TEXT command showing the proper
syntax for the field_info parameter. To be consistent with the rest of
the DDE commands in the application, I need to use the old macro
functions (Excel 4.0) rather than Visual Basic. FYI, the syntax below
works fine without the field_info at the end:

[OPEN.TEXT("C:\TEMP\TEST.TXT",2,1,1,3,
FALSE,TRUE,FALSE,FALSE,FALSE,FALSE)]

I've tried the following and other variations of it at the end, but I
can't get the field_info parameter to work:

[OPEN.TEXT("C:\TEMP\TEST.TXT",2,1,1,3,
FALSE,TRUE,FALSE,FALSE,FALSE,FALSE,{{1,2},{2,2},{3,2}})]

Any suggestions would be greatly appreciated.

 

[Vasant Nanavati]

Not tested, but try:

[OPEN.TEXT("C:\TEMP\TEST.TXT",2,1,1,3,FALSE,TRUE,FALSE,FALSE,FALSE,FALSE,Arr
ay(Array(1, 2), Array(2, 2), Array(3, 2)))]