Text to Columns with VBA

[Pesman]

I've figured out how to find and import a text file into a sheet using VBA.

I've been fighting for a couple of days now on how to convert the text into columns.
I've tried recording a macro and that works fine, however, the problem is that the number of rows is not constant.

Does anyone have a quick and dirty way of doing this?

 

[Barrie Davidson]

On 2002-09-24 05:28, Pesman wrote:
I've figured out how to find and import a text file into a sheet using VBA.

I've been fighting for a couple of days now on how to convert the text into columns.
I've tried recording a macro and that works fine, however, the problem is that the number of rows is not constant.

Does anyone have a quick and dirty way of doing this?

Something like this should work:

Range("A1:A" & Range("A65536").End(xlUp).Row).TextToColumns DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 2), Array(7, 2))

Just change the field info to your requirements.

Regards,

 

[Barrie Davidson]

On 2002-09-24 05:28, Pesman wrote:
I've figured out how to find and import a text file into a sheet using VBA.

I've been fighting for a couple of days now on how to convert the text into columns.
I've tried recording a macro and that works fine, however, the problem is that the number of rows is not constant.

Does anyone have a quick and dirty way of doing this?

oops, **** SLOW board!!
_________________

Barrie Davidson
My Excel Web Page
This message was edited by Barrie Davidson on 2002-09-24 06:25