Djblois
02-01-2010, 08:09 AM
How can I change this to not be fixed width:
Workbooks.OpenText filename:=UsGrowersTextFile, _
Origin:=437, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array( _
Array(0, 1), Array(49, 1)), TrailingMinusNumbers:=True
I want it to be comma separated. However, it does not autocomplete for me to find the DataType for .csv
Workbooks.OpenText filename:=UsGrowersTextFile, _
Origin:=437, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array( _
Array(0, 1), Array(49, 1)), TrailingMinusNumbers:=True
I want it to be comma separated. However, it does not autocomplete for me to find the DataType for .csv