Cetin,

Thanks for the reply.
My text file is delimited with ';'.But I just need to create the .xls from .txt file, do not want to open it at the same time, User will open it later on.