If you record a macro when you do this import, you'll have the code for each
field.

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 isnt imported correctly.
Is there a parameter that can also specify column formats? I dont mind even
if there is a parameter to make the wizard show also.

Thanks

Kevin

--

Dave Peterson