I wish to convert a txt file that is saved down in my folder into a .xls file.

Before I do this however I need to sort by columns and I wish to sort by using the delimited file type - Other | key.

Once created as a .xls file.

I need to import the file into my workbook under worksheet "US Pennies"

Any ideas how I can do this?

File path the txt file is save under is

N/My Documents.