I am trying to do exactly what the title says.... Take File.txt which has columns separated/delimited by the character "|" .
When using excel manually, I have to open excel and then browse to File.txt, then choose "Text" as the file type then since I'm opening a text document with Excel the "Text Import Wizard" comes up... I choose 'Delimited' as the 'original data type' , accept all other defaults, then on step 2 of the wizard I select 'Other' as the delimiter and | in the 'Other:' field. The next page I leave default as General, and click finish.
Now my text file data is open in Excel.....
There must a way to automate this!!