Hi there,

I am using the workbooks.open method to open a tab
delimited text file. The problem is that I need the
format of one (or all) of the columns to be changed
to "text". The numbers in the column in question are
account numbers and are 16 digits long. They are
expressed in exponential form when I use the open method.
When I change the format of the column to "text" after
opening the file, it shows the exponential form as text.

If the above is not clear:
When opening a text file in excel manually, one is
normally taken through a wizard where you can choose the
delimiters etc. The last window in this wizard previews
the columns and allows one to change the format of any
column to text. Essentially, I need the VBA code that
will perform this operation.

Many thanks in advance!
keno