conversion of text file(delimited) into Excel file using macro

Hi,

Data existing in .txt file. with enclosed file format.(this format of txt file will generated from one of the ERP system)
But Required in Excel Format file
one method is Open text file(Ctrl+O) using "Text import wizard"
with Fixed delimited --->breaking at semicolon --finish..
then taking all data in notepad replace ; with blank then formatting cells as text/date/custom format in excel
then pasting all data from notepad to excel.


EMP_CODE --- Text format
ATTN_DATE --- Date foramt as yyyy-mm-dd
DEPT_CENTER_CODE --- Text format
MONTH_CODE--- Text format
FROM_TIME --- foramt as yyyy-mm-dd hh:mm:ss
TO_TIME--- foramt as yyyy-mm-dd hh:mm:ss
SECTION_CODE --- Text format

required such that what ever in text file(delimited) has to open in regular format of excel..
Please suggest me how to write a macro script with Run button.


Thanks,
Thara