I am using Vb2005 and open a text file in Excel 2007.
As soon as finesed open Excel do not respond and exit.
Dim columnarray(,) As String = New String(,) {{1, 1}, _
{4, 1}, {10, 1}, {16, 1}, {20, 1}, _
{21, 1}, {29, 1}, {29, 1}, {37, 1}, _
{38, 1}, {44, 1}, {65, 1}, {73, 1}, _
{81, 1}, {89, 1}, {97, 1}, {105, 1}}
xlApp.Workbooks.OpenText(Filename:=par_ICDF_Dest & "ICDF.dat", _
Origin:=Excel.XlPlatform.xlMSDOS, _
StartRow:=1, DataType:=Excel.XlTextParsingType.xlFixedWidth, _
FieldInfo:=columnarray,)
xlBook = xlApp.ActiveWorkbook
Can someone help please.
As soon as finesed open Excel do not respond and exit.
Dim columnarray(,) As String = New String(,) {{1, 1}, _
{4, 1}, {10, 1}, {16, 1}, {20, 1}, _
{21, 1}, {29, 1}, {29, 1}, {37, 1}, _
{38, 1}, {44, 1}, {65, 1}, {73, 1}, _
{81, 1}, {89, 1}, {97, 1}, {105, 1}}
xlApp.Workbooks.OpenText(Filename:=par_ICDF_Dest & "ICDF.dat", _
Origin:=Excel.XlPlatform.xlMSDOS, _
StartRow:=1, DataType:=Excel.XlTextParsingType.xlFixedWidth, _
FieldInfo:=columnarray,)
xlBook = xlApp.ActiveWorkbook
Can someone help please.