Hi,
I can able to run the Excel Macro command in VB6. Unfortunately , VB.Net
always prompt Array - no declaring. I've insert the Excel references, and it
is still not working. Can anyone help me ? Thanks.
Source code:-
xl.Workbooks.OpenText(Filename:="C:\SMT\SMT.TXT",
Origin:=Excel.XlPlatform.xlWindows, StartRow _
:=1, DataType:=Excel.XlTextParsingType.xlDelimited,
TextQualifier:=Excel.XlTextQualifier.xlTextQualifi erNone,
ConsecutiveDelimiter _
:=False, TAB:=True, Semicolon:=False, Comma:=False, Space:=False, _
Other:=False, FieldInfo:=Array(Array(1, 2), Array(2, 2), Array(3, 1),
Array(4,2),Array(5, 2)))