I very regularly need to import text file to excel. Text file format is fixed. It is a fixed width format. ie let us say in each line the characters 1-10 represent date, 11-40 name, 41-50 amount etc. I want to automate import the process so that in the excel sheet first col contains the date, next name and third amount. Manually I can do it by opening the file but then I have to go through the wizard, select field width, type of data etc. I want to write a sub so that it will pick the text file and convert to excel with right data type ( date as date, name as text, amount as number ). Please help.

A V Veerkar