Text to Columns
 

I have a macro which parses a comma delimited string, but have just
discovered an issue (XL2000)...

The output from this macro is input for further processing BUT apparently the
default behaviour for Excel is that once the Text to Columns action has been
performed, to continue doing it... problem is, subsequent entries that
contain comma's are being automagickally parsed, with the result that some
data is then being overwritten (because it's parsed into the wrong columns).

is there some way to cancel this once the intial macro has been completed?

TIA

S
--
there are 10 types of people in this world
those who understand binary, and those who don't...

Text to Columns
 

Hi,

how about doing 'TextToColumns' again. for instance,

Sub Init_TextToColumns()
Application.ScreenUpdating = False
With Workbooks.Add(xlWorksheet).Worksheets(1)
.Range("A1").Value = "a"
.Range("A1").TextToColumns Destination:=.Range("A1"), _
DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False
.Parent.Close False
End With
Application.ScreenUpdating = True
End Sub


i know the setting of 'TextToColumns' and 'OpenText' affects pasting
text from clipboard. is there any other thing affected?

--
HTH,

okaizawa


Simon wrote:
I have a macro which parses a comma delimited string, but have just
discovered an issue (XL2000)...

The output from this macro is input for further processing BUT apparently the
default behaviour for Excel is that once the Text to Columns action has been
performed, to continue doing it... problem is, subsequent entries that
contain comma's are being automagickally parsed, with the result that some
data is then being overwritten (because it's parsed into the wrong columns).

is there some way to cancel this once the intial macro has been completed?

TIA

S

Text to Columns
 

Simon wrote:
I'll give it a go (I had thought about this but thought that there should be
a better way...)

sorry, i don't know any way to handle this directly.
i don't think this feature to be very useful. i want some choices.

--
Regards,

okaizawa