The Text Wizard third step has the function to select the columns and designate
what format. Text, General, Date or do not import.

Record a macro while you're importing the text file to get the code.


Gord Dibben MS Excel MVP

On Tue, 6 Nov 2007 16:34:01 -0800, Uradox
wrote:

Hi

I wrote a parser for my company that creates excel friendly text files that
saves a lot of time importing them manually. The text file is formatted in
such a way excel can read the correct column sizes and all data is imported
perfectly.
Normally if you open this text file in excel the import text wizard pops up.
Now to the problem

I wish my parser tool to automatically open the txt file in excel as it does
via parameters. However I need to change the column data format (last option
in the text wizard). By default excel imports everything as General. The last
column needs to be text else the data isn’t imported correctly.
Is there a parameter that can also specify column formats? I don’t mind even
if there is a parameter to make the wizard show also.

Thanks

Kevin