View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Uradox Uradox is offline
external usenet poster
 
Posts: 2
Default Importing text files automaticly.

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