Hello,
I am trying to import a number of text files in one sheet.
If I am using the line below, a new workbook will open. How can I import a text file in an open excel workbook?
Workbooks.OpenText Filename:=fln, Origin:=437, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array( _
Array(0, 1), Array(12, 1), Array(26, 1), Array(45, 1), Array(66, 1), Array(86, 1), Array( _
106, 1), Array(126, 1)), TrailingMinusNumbers:=True
Thank you
I am trying to import a number of text files in one sheet.
If I am using the line below, a new workbook will open. How can I import a text file in an open excel workbook?
Workbooks.OpenText Filename:=fln, Origin:=437, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array( _
Array(0, 1), Array(12, 1), Array(26, 1), Array(45, 1), Array(66, 1), Array(86, 1), Array( _
106, 1), Array(126, 1)), TrailingMinusNumbers:=True
Thank you