I searched google and found a post by Bernie Deitrick:

http://google.co.uk/groups?threadm=O...GP10.phx .gbl

It may give you some ideas.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

uriel78 wrote:

I've a *.txt file with data organized in about 1000 columns.
Is there a way to open this txt file in excel transposing each column in a
row ??

--

Dave Peterson