#### Osmar Morais

##### New Member

I listed below the command generated for Excel macro:

Workbooks.OpenText Filename:="C:\TEMP\es1203a090810-042150.sdf", Origin:= _

xlMSDOS, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote _

, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True, Comma:= _

False, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 2), Array(2, 2) _

, Array(3, 1), Array(4, 1), Array(5, 2), Array(6, 1), Array(7, 2), Array(8, 4), Array(9, 2), _

Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 4), Array(14, 2), Array(15, 1), Array( _

16, 1), Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1)), TrailingMinusNumbers _

:=True

I tryed:

ASSIGN chWB2 = chXL:Workbooks:OPENTEXT(cFile1,,1,1,2,False,False,True,False,False,False,iFormat,True).

Where "iFormat" is a extent integer variable with the related field type, I used this variable because I don´t know hou to write this information (Array(1,2), Array(2,2), and so on) in OpenEdge COM Sintaxe, I also tryed to use a temp-table and to to enclose in quotas, without success.

If someone had faced this problem and could help me I thank.