I'm trait to open a text file with Excel, but I don't who a pass a array of array's. Help please!!
Workbooks.OpenText Filename:=
"C:\ssm.txt",
Origin:=xlMSDOS,
StartRow:=1,
DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote,
ConsecutiveDelimiter:=False,
Tab:=False,
Semicolon:=False,
Comma:=False,
Space:=False,
Other:=True,
OtherChar:="|",
FieldInfo:=Array(Array(1, 1), Array(2, 2), Array(3, 1)), <--------------------------- Problems
TrailingMinusNumbers:=True
I can open a file with WORKBOOKS:OpenText("c:\ssm.txt",3,2,1,2,,,,,,YES,"|",,,,,,TRUE), but if I use WORKBOOKS:OpenText("c:\ssm.txt",3,2,1,2,,,,,,YES,"|",Array(Array(1, 1), Array(2, 2), Array(3, 1)),,,,,TRUE) senme an error. I don´t who syntx use to express "Array(Array(1, 1), Array(2, 2), Array(3, 1))"
El mensaje fue editado por: Sergio Sosa