text to column

[owl527]

Hi,
I have a bunch of files that I have extract data from everyday. However, I need to use the "text to column" function before I could sort the file. I would like to create a macro to help me do the job so then I don't have to do it everyday. Is it possible to write a "text to column" macro? if so, how can I do that? Please let me know. Thank you very much.

[Norman Jones]

Hi Owl.

Try turning on the macro recorder as you perform the required operations.
The resultant code may be edited to enable more general use.

If you experience problems with this editing, post back with details.


---
Regards,
Norman


"owl527" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> I have a bunch of files that I have extract data from everyday.
> However, I need to use the "text to column" function before I could
> sort the file. I would like to create a macro to help me do the job so
> then I don't have to do it everyday. Is it possible to write a "text to
> column" macro? if so, how can I do that? Please let me know. Thank you
> very much.
>
>
> --
> owl527
> ------------------------------------------------------------------------
> owl527's Profile:
> http://www.excelforum.com/member.php...o&userid=20916
> View this thread: http://www.excelforum.com/showthread...hreadid=517635
>