R
Rosson Cain
I recorded the importation of a prn file and the VB code
that came out is below. My question is, does anybody know
where the code specifies what data type each column is
(text, number, date, etc.) any help would be
appreciated. thanks.
Workbooks.OpenText FileName:= _
fileToOpen, Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False,
Semicolon:=False, Comma:=True _
, Space:=False, Other:=False, FieldInfo:=Array
(Array(1, 2), Array(2, 1), _
Array(3, 1), Array(4, 2), Array(5, 2), Array(6,
1), Array(7, 1), Array(8, 1), Array(9, 1), _
Array(10, 1), Array(11, 1), Array(12, 1), Array
(13, 1), Array(14, 1), Array(15, 1), Array( _
16, 1))
that came out is below. My question is, does anybody know
where the code specifies what data type each column is
(text, number, date, etc.) any help would be
appreciated. thanks.
Workbooks.OpenText FileName:= _
fileToOpen, Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False,
Semicolon:=False, Comma:=True _
, Space:=False, Other:=False, FieldInfo:=Array
(Array(1, 2), Array(2, 1), _
Array(3, 1), Array(4, 2), Array(5, 2), Array(6,
1), Array(7, 1), Array(8, 1), Array(9, 1), _
Array(10, 1), Array(11, 1), Array(12, 1), Array
(13, 1), Array(14, 1), Array(15, 1), Array( _
16, 1))