Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlTextFormat in TextToColumns
I am parsing fixed width data with the following code:
Range("a1", ActiveCell.SpecialCells(xlLastCell)).Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(8, 1), Array(11, 9), Array(12, 1)) The data in the last array is numeric. I need it to be brought in as text so as not to loose the leading zeros. How do I apply xlTextFormat? Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlTextFormat in TextToColumns
Array(12, 1)
becomes Array(12, xlTextFormat) or Array(12, 2) Sometimes, it's quicker to record a macro when you do this manually and look at the code. CinqueTerra wrote: I am parsing fixed width data with the following code: Range("a1", ActiveCell.SpecialCells(xlLastCell)).Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(8, 1), Array(11, 9), Array(12, 1)) The data in the last array is numeric. I need it to be brought in as text so as not to loose the leading zeros. How do I apply xlTextFormat? Thanks in advance! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlTextFormat in TextToColumns
Awesome - Thanks!
"Dave Peterson" wrote: Array(12, 1) becomes Array(12, xlTextFormat) or Array(12, 2) Sometimes, it's quicker to record a macro when you do this manually and look at the code. CinqueTerra wrote: I am parsing fixed width data with the following code: Range("a1", ActiveCell.SpecialCells(xlLastCell)).Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _ FieldInfo:=Array(Array(0, 1), Array(8, 1), Array(11, 9), Array(12, 1)) The data in the last array is numeric. I need it to be brought in as text so as not to loose the leading zeros. How do I apply xlTextFormat? Thanks in advance! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sub TextToColumns | Excel Programming | |||
Q TextToColumns | Excel Programming | |||
texttocolumns | Excel Programming | |||
TextToColumns | Excel Programming | |||
TextToColumns Dialog | Excel Programming |