TextToColumns Method: How to use xlFixedWidth?

[Guest]

I am trying to simulate what I do manually with the Text to Column function
in Datas menu. Basically I have a range select, I go to T to C function, I
chose FixedWidth, then but 2 separators at 30 and 60. How would I do that
using the TextToColumns in VB?

 

[Dave Peterson]

VB or VBA?

In VBA, I'd record a macro when I did it manually.

In VBA, I'd record a macro when I did it manually and then try to change it to
run from VB.